|
Sub test()
Dim A, B, C, i, j
A = Range("a1").CurrentRegion
B = Range("h1").CurrentRegion
ReDim C(1 To UBound(A), 1 To UBound(A, 2) * 2 - 1)
For i = 1 To UBound(A)
'第1列
C(i, 1) = A(i, 1)
'其它列
For j = 2 To UBound(A, 2)
C(i, j) = A(i, j)
C(i, j + UBound(A, 2) - 1) = B(i, j)
Next j
Next i
[a25].Resize(UBound(C), UBound(C, 2)) = C
End Sub
数组合并2.rar
(11.94 KB, 下载次数: 24)
|
|