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
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
Last edited by Rick Rothstein; 04-05-2012 at 08:55 AM.
Thanks Rick for your quick reply.
Bookmarks