|
- Sub a()
- Dim i As Integer, j As Integer
- Dim arr, brr, k%, x%, y%
- arr = Range("a1").CurrentRegion
- ReDim brr(1 To UBound(arr) * UBound(arr, 2) / 2, 0 To 1)
- For i = 1 To UBound(arr)
- For j = 1 To UBound(arr, 2)
- k = k + 1
- x = Application.RoundUp(k / 2, 0)
- y = (j + 1) Mod 2
- brr(x, y) = arr(i, j)
- Next j
- Next i
- Range("a4").Resize(x, 2) = brr
- End Sub
复制代码 见附件示例 |
|