| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
