右边的模拟结果有问题,i6的54不要了吗?
Sub test()
Dim arr, brr, i&, j%, n&
arr = [a2:i6]
ReDim brr(1 To UBound(arr, 2) * 2, 1 To 3)
For j = 1 To UBound(arr, 2) Step 3
For i = 1 To UBound(arr)
n = n + 1
brr(n, 1) = arr(i, j)
brr(n, 2) = arr(i, j + 1)
brr(n, 3) = arr(i, j + 2)
Next
Next
[p2].Resize(UBound(brr), 3) = brr
End Sub
|