How can I append an array to another in Excel VBA?
I have a loop, and in each iteration, a new array of variant type is created. The output at the end of the loop should be all the arrays appended together. The number of columns in each array are always the same.
For Each cell In Worksheets("Sheet2").Range(MRG)
'An array is generated at each iteration. Append generated array to the already existing array, which is empty at iteration 1. Lowerbound=0 for both dimension, upper bound varies for 1st dimension (rows) of array at each iteration. No of columns are always same for each new array.
Appreciate any help.