vba两个数组合并成一个

VBA中可以使用For循环来合并两个数组。例如，如果你有两个数组A和B，你可以定义一个新的数组C，并使用For循环向该数组C中添加元素，以便合并两个数组。代码如下：

Dim A(1 To 5) As Integer, B(1 To 5) As Integer, C(1 To 10) As Integer Dim i As Integer, j As Integer

For i = 1 To 5 A(i) = i Next i

For i = 1 To 5 B(i) = i + 5 Next i

j = 0 For i = 1 To 5 j = j + 1 C(j) = A(i) j = j + 1 C(j) = B(i) Next i

这就是将两个数组合并成一个数组的方法。