arrays - 如何在 VBA 中合并两个数组？

Question

给定的

Dim arr1 As Variant
Dim arr2 As Variant
Dim arr3 As Variant

arr1 = Array("A", 1, "B", 2)
arr2 = Array("C", 3, "D", 4)

我可以对 arr1 和 arr2 进行什么样的操作并将结果存储在 arr3 中，以便:

arr3 = ("A", "C", 1, 3, "B", "D", 2, 4)

Answer 1

尝试这个:

arr3 = Split(Join(arr1, ",") & "," & Join(arr2, ","), ",")