6,210
社区成员
发帖
与我相关
我的任务
分享
Sub test()
Dim arr, i%, j&, k&
ReDim arr(1 To Sheets(1).[a1].CurrentRegion.Rows.Count * 3)
For j = 1 To UBound(arr) / 3
For i = 1 To 3
k = k + 1
arr(k) = Sheets(i).Cells(j, 1)
Next
Next
Sheets(4).[a1].Resize(k) = WorksheetFunction.Transpose(arr)
End Sub