本帖最后由 dsmch 于 2014-2-20 21:50 编辑
- Sub Macro1()
- Dim arr, brr, i&
- arr = Range("a3:c" & Range("c65536").End(xlUp).Row)
- ReDim brr(1 To UBound(arr), 1 To 6)
- For i = 1 To UBound(arr) - 2 Step 4
- brr(i, 1) = arr(i, 1) & arr(i + 1, 2) & arr(i + 2, 3)
- brr(i, 2) = arr(i + 2, 1) & arr(i + 1, 2) & arr(i, 3)
- brr(i, 3) = arr(i + 1, 1) & arr(i, 2) & arr(i + 2, 3)
- brr(i, 4) = arr(i, 2) & arr(i + 1, 3) & arr(i, 1)
- brr(i, 5) = arr(i, 1) & arr(i + 1, 3) & arr(i + 2, 2)
- brr(i, 6) = arr(i, 3) & arr(i + 2, 2) & arr(i + 1, 1)
- Next
- [d:i].NumberFormatLocal = "@"
- Range("d3").Resize(UBound(brr), UBound(brr, 2)) = brr
- End Sub
复制代码 |