- Sub aaa()
- Dim arr, brr, i&, j&, k&, s$
- arr = Sheets(1).[a1].CurrentRegion
- ReDim brr(1 To UBound(arr) - 4, 1 To UBound(arr, 2) * 2)
- For j = 1 To UBound(arr, 2)
- For i = 1 To UBound(arr) - 4
- For k = i To i + 3
- s = s & arr(k, j)
- Next k
- brr(i, (j - 1) * 2 + 1) = s
- brr(i, (j - 1) * 2 + 2) = arr(i + 4, j)
- s = ""
- Next i
- Next j
- Sheets(2).[a1].Resize(UBound(brr), UBound(brr, 2)) = brr
- End Sub
复制代码 |