|
请教下各位老师,如何批量指定数量进行复制粘贴到表2中,并且每行按四列排列,谢谢!
- Sub aaa()
- Dim arr, brr, i&, j&, r&, c&
- arr = Sheets(1).[a1].CurrentRegion
- ReDim brr(1 To -Int(-Application.Sum(arr) / 4), 1 To 4)
- r = 1
- For i = 2 To UBound(arr)
- For j = 1 To arr(i, 2)
- c = c + 1
- If c = 5 Then c = 1: r = r + 1
- brr(r, c) = arr(i, 1)
- Next j
- Next i
- Sheets(2).[a1].Resize(r, 4) = brr
- End Sub
复制代码
|
|