Coverting a VBA array from 2-D to 1-D
I know I can quickly map a 2d range to an array with code such as
Sub MyArr()
Dim myarray
myarray = [A1:D2]
End Sub
Is there a quick way to convert the array into a single dimension without
using a FOR loop?
I want to end up with an array of two elements, the first containing a
concatenated string of A1 to D1 the second of A2 to D2.
Thanks
|