Combining data of Two Array or Range

[Rick Rothstein]

thanks for quick reply.

this is a 2D array of VBA which holds the data of two ranges.And I want this data to be displayed as in example:
arr1= 1 2 3
2 3 4
arr2= q q r
s t u
resArr=1 2 3
2 3 4
p q r
s t u

This is not a trivial thing to do; however, here is a website that includes code to do it...

VBA Arrays

There is a description of how to use the code in a section titled "CombineTwoDArrays". To go directly to the code, search the webpage for this text string...

Public Function CombineTwoDArrays