|
Sub test()
Dim i%, j%, arr(), m%, n%, rng As Range
m = Range("k1").CurrentRegion.Columns.Count
n = Int(m / 4)
ReDim arr(1 To n)
For i = 11 To m + 10 Step 4
j = j + 1
arr(j) = Cells(1048576, i).End(xlUp).Resize(1, 3)
Next
Set rng = Range("k1048576").End(xlUp).Offset(1, 0).Resize(n, 3)
rng = Application.Transpose(Application.Transpose(arr))
rng.Select
End Sub
|
评分
-
查看全部评分
|