普通浏览复制代码保存代码打印代码
-
Sub yy()
-
Dim i&, Myr&, r%, Arr, Arr1()
-
Sheet1. Activate
-
Myr = [q65536]. End(xlUp).Row
-
Arr = Range( "o1:q" & Myr)
-
For i = 2 To UBound(Arr)
-
If Arr(i, 1) > 0 Then
-
r = r + 1
-
ReDim Preserve Arr1( 1 To 2, 1 To r)
-
Arr1( 1, r) = Arr(i, 1)
-
Arr1( 2, r) = Arr(i, 3)
-
End If
-
Next
-
[s1].Resize(r, 2) = Application.Transpose(Arr1)
-
End Sub
|