Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Set a 2D arrray data into a range, given the top-left cell
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Set a 2D arrray data into a range, given the top-left cell
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" 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Set a 2D arrray data into a range, given the top-left cell
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" 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell data format | Excel Discussion (Misc queries) | |||
Summed Cell won't update as I add data into the cell range... | Excel Worksheet Functions | |||
How to enter data in one row cell only in a cell range | Excel Worksheet Functions | |||
highlight range if cell contains desired data | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions |