View Single Post
  #18   Report Post  
Posted to microsoft.public.excel.programming
Dave[_37_] Dave[_37_] is offline
external usenet poster
 
Posts: 4
Default 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