|
现有多列数据,欲倒序合并成一列,用宏代码如何实现?
示例:
I列 J列 K列 L列
01 | 11 | 21 | 31 | 02 | 12 | 22 | 32 | 03 | 13 | 23 | 33 | 04 | 14 | 24 | 34 | 05 | 15 | 25 | 35 | 06 | 16 | 26 | 36 | 07 | 17 | 27 | 37 | 08 | 18 | 28 | 38 | 09 | 19 | 29 | 39 | 10 | 20 | 30 | 40 | 倒序合并成一列,写入N列
10 20 30 40 | 09 19 29 39 | 08 18 28 38 | 07 17 27 37 | 06 16 26 36 | 05 15 25 35 | 04 14 24 34 | 03 13 23 33 | 02 12 22 32 | 01 11 21 31 |
- Sub 数据合并()
- Dim ARR, BRR(), K As Integer, M As Integer, L As Integer, S As Byte
- L = Range("I65536").End(xlUp).Row
- ARR = Range("I7:L" & L)
- ReDim BRR(1 To 1000)
- For K = UBound(ARR) To 1 Step -1
- M = M + 1
- For S = 1 To UBound(ARR, 2)
- BRR(M) = BRR(M) & ARR(K, S) & " "
- Next
- Next
- Range("N7").Resize(M, 1) = Application.Transpose(BRR)
- End Sub
复制代码
|
|