Read the entire range into a variant with one operation, then remap the
elements into another array any way you wish.

--
http://www.standards.com/; See Howard Kaikow's web site.
"Dave" wrote in message
u...
Hi Bob,

I want to run a routine on the usedrange so there could be up to 256
values
per element

I thought or maybe more accurately hoped that there may be some sort of
array conversion I could do - I was concerned that a FOR loop would take
a
long time on say 200 columns by 10000 rows

Is a loop the only way?

Thanks

Dave


"Bob Phillips" wrote in message
...
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