Set a 2D arrray data into a range, given the top-left cell

T

Tom Chau

Hi all,

I hope to ask whether there is some convenient way to assign a 2D array
data into a range by specifiying the top-left cell (e.g., A1). I'm
looking for something like "CopyFromRecordset".

Would any body have previous experience on that? Is the looping really
necessary?

Thanks a lot.

Tom
 
J

Jim Cone

Tom,
Range("A1").Resize(UBound(MyArray, 1), UBound(MyArray, 2)).Value = MyArray
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Tom Chau" <[email protected]>
wrote in message
Hi all,
I hope to ask whether there is some convenient way to assign a 2D array
data into a range by specifiying the top-left cell (e.g., A1). I'm
looking for something like "CopyFromRecordset".
Would any body have previous experience on that? Is the looping really
necessary?
Thanks a lot.
Tom
 
Top