|
Sub test()
Dim A(1 To 1, 1 To 55), j, x
Sheets(1).Select
A(1, 1) = [G1]
A(1, 2) = [F1]
A(1, 3) = [E1]
j = 3
For Each x In [f3:j13]
If j = UBound(A, 2) Then Exit For
j = j + 1
A(1, j) = x
Next
Sheets(2).Select
Cells(Range("a65536").End(xlUp).Row + 1, 1).Resize(1, UBound(A, 2)) = A
End Sub
1.rar
(6.35 KB, 下载次数: 4)
|
|