Dim A() As Integer Dim B() As Integer Dim LA As Long Dim LB As Long Dim i% ReDim A(2) ReDim B(2) '给A,B赋值 A(0) = 1 A(1) = 2 A(2) = 3 B(0) = 4 B(1) = 5 B(2) = 6 '赋值结束 LA = UBound(A) - LBound(A) + 1 LB = UBound(B) - LBound(B) + 1 ReDim Preserve A(LA + LB - 1) For i = LA To LA + LB - 1 A(i) = B(i - LA) Next