Posted on 2011-09-16
I'm working on another solution and need to create an array of 3MM values, stored in column A, B, and C in Excel 2007.
I can assign the range by setting three range variables to the three columns, then
rTotal = Union(rFirst,rSecond,rThird)
I'd like to convert this one 2-D array into a 1-D array, without having to iterate through every element.
Any clever ideas on how to load 3 MM records from 3 ranges, or how to convert a 2-D to a 1-D more expeditiously?