|
发表于 2013-7-10 17:42
|
显示全部楼层
本楼为最佳答案
本帖最后由 爱疯 于 2013-7-10 17:45 编辑
Sub test2()
Dim A(), B
Dim r, c, i, j, k
B = Sheet2.Range("a1").CurrentRegion
r = UBound(B): c = UBound(B, 2)
B(r, 1) = 1 '加标记
For j = 1 To c
If B(r, j) > 0 Then
k = k + 1
ReDim Preserve A(1 To r, 1 To k)
For i = 1 To r
A(i, k) = B(i, j)
Next i
End If
Next j
A(r, 1) = "" '取消标记
With Sheet1
.Cells.Clear
.Range("a1").Resize(r, k) = A
End With
End Sub
求助again2.rar
(20.41 KB, 下载次数: 19)
|
|