|
本帖最后由 阿力力 于 2024-6-1 21:13 编辑
问题已解决,谢谢gwjkkkkk大师!同时也感谢回复的几个大师。
gwjkkkkk大师写的代码:
Option Explicit
Sub TEST2()
Dim ar, br, cr, i&, j&, k&, r&, n&
Application.ScreenUpdating = False
ar = Range("B38", Cells(Rows.Count, "g").End(xlUp)).Value
br = Range("H38", Cells(Rows.Count, "J").End(xlUp)).Value
ReDim cr(1 To UBound(ar) * UBound(br), 1 To UBound(ar, 2) + UBound(br, 2))
For i = 1 To UBound(ar)
For k = 1 To UBound(br)
r = r + 1: n = 0
For j = 1 To UBound(ar, 2)
n = n + 1
cr(r, n) = ar(i, j)
Next j
For j = 1 To UBound(br, 2)
n = n + 1
cr(r, n) = br(k, j)
Next j
Next k
Next i
Range("BB2").Resize(UBound(cr), UBound(cr, 2)) = cr
Application.ScreenUpdating = True
Beep
End Sub
|
|