|
- Sub aa()
- Dim arr, Ro As Long, Co As Long
- Dim arr1
- Dim i As Long, j As Long
- Ro = [A65536].End(xlUp).Row
- Co = Range("A1").End(xlToRight).Column
- arr = Range(Cells(1, 1), Cells(Ro, Co))
- ReDim arr1(1 To (UBound(arr) - 1) * 2, 1 To UBound(arr, 2))
- For i = 2 To UBound(arr)
- For j = 1 To UBound(arr, 2)
- arr1((i - 1) * 2, j) = arr(i, j)
- arr1((i - 1) * 2 - 1, j) = arr(1, j)
- Next j
- Next i
- Sheets("sheet2").Range("A1").Resize(UBound(arr1), UBound(arr1, 2)) = arr1
- End Sub
复制代码 附件:
插入-sunjing.rar
(9.18 KB, 下载次数: 4)
|
|