How do I Merge two Arrays in VBA?

arrays vba vb6 merge
Kevin Boyd picture Kevin Boyd · Oct 19, 2009 · Viewed 103.1k times · Source

Given 

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

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

What kind of operations can I do on arr1 and arr2 and store result in arr3 such that: 

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

Answer

user3286479 picture user3286479 · Jan 9, 2017

Try this:

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

Related questions

VBA array sort function?

I'm looking for a decent sort implementation for arrays in VBA. A Quicksort would be preferred. Or any other sort algorithm other than bubble or merge would suffice. Please note that this is to work with MS Project 2003, so should …

Read More
Declare and Initialize String Array in VBA

This should work according to another stack overflow post but its not: Dim arrWsNames As String() = {"Value1", "Value2"} Can anyone let me know what is wrong?

Read More
How to clear the entire array?

I have an array like this: Dim aFirstArray() As Variant How do I clear the entire array? What about a collection?

Read More