Coverting a VBA array from 2-D to 1-D
Dave,
If that is all you want and you don't want loops, why not just use
Dim myarray(1)
myarray(0) = [A1] & [B1] & [C1] & [D1]
myarray(1) = [A2] & [B2] & [C2] & [D2]
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Dave" wrote in message
u...
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
|