|
- Sub demo1()
- Dim arr, re
- Dim i As Long, j As Long, k As Long, cnt As Long
- arr = Sheets("sheet2").UsedRange.Value
- ReDim re(1 To 100000, 1 To 2)
- For i = 0 To UBound(arr) Step 11
- For j = 0 To UBound(arr, 2) Step 3
- For k = 1 + i To 10 + i
- cnt = cnt + 1
- re(cnt, 1) = arr(k, j + 1)
- re(cnt, 2) = arr(k, j + 2)
- Next
- Next
- Next
- Sheets("sheet3").Range("A1").Resize(cnt, 2) = re
- Sheets("sheet2").Cells.ClearContents
- End Sub
复制代码 |
|