|
- Sub test()
- Dim arr, ar, brr(), i&, j&
- ar = Array(1, 2, 3, 4, 5, 11, 12, 13, 18, 19, 20, 21, 22)
- arr = Sheets("Sheet0").Range("a1").CurrentRegion
- ReDim brr(1 To 2 * UBound(arr), 12)
- For i = 1 To UBound(arr)
- For j = 0 To UBound(ar)
- If i > 1 Then
- brr((i - 1) * 2, j) = arr(i, ar(j))
- Else
- brr(i, j) = arr(i, ar(j))
- End If
- Next
- Next
- With Sheets("Sheet1")
- .Cells.Borders.LineStyle = 0
- .Cells.ClearContents
- With .Range("a1").Resize(UBound(brr) - 1, 13)
- .Value = brr
- .Borders.LineStyle = 1
- End With
- End With
- End Sub
复制代码
例文.rar
(26.18 KB, 下载次数: 4)
|
|