|
发表于 2012-1-6 11:32
|
显示全部楼层
本楼为最佳答案
- Sub aa()
- Dim arr, arr1()
- Dim i As Long
- arr = Range("A3:O" & [A65536].End(xlUp).Row)
- ReDim arr1(1 To UBound(arr) * 2, 1 To 7)
- Sheets("记录表").Range("A2:G" & Sheets("记录表").[A65536].End(xlUp).Row + 1).ClearContents
- For i = 1 To UBound(arr)
- arr1(i * 2 - 1, 1) = arr(i, 1)
- arr1(i * 2 - 1, 2) = arr(i, 3)
- arr1(i * 2 - 1, 3) = arr(i, 7)
- arr1(i * 2 - 1, 4) = arr(i, 8)
- arr1(i * 2 - 1, 5) = arr(i, 9)
- arr1(i * 2 - 1, 6) = arr(i, 14)
- arr1(i * 2 - 1, 7) = arr(i, 15)
- arr1(i * 2, 3) = arr(i, 4)
- arr1(i * 2, 4) = arr(i, 5)
- Next i
- Sheets("记录表").Range("A2").Resize(UBound(arr1), UBound(arr1, 2)) = arr1
- End Sub
复制代码
|
|