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

  • Thread starter Thread starter Tom Chau
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transfering 2D Array into 1D Array 2
Split Cell Range into Multiple Cells 1
Redimming 2D array to 1D while preserving the data? 8
Scroll a cell to the top left hand corner of the screen 2
How do I select a range of cells in an Excel table using the mouse 1
how do I extract data from worksheet to VBA? 4
Using a cell in the worksheet as a range in a VBA routine 2
Setting a range.value equal to /part/ of a (3D) variant array? 3

Back
Top