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

[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

[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

[Tom Chau]

Hi Jim,

It works very well. Thanks a lot.

Tom


Jim Cone wrote:
> 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