| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy a 2 dimensional array to a range
Hello,
What would be the most fastest way to copy a 2 dimensional array (rXc) to a range starting at cell A1? Thanks Avi |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy a 2 dimensional array to a range
What would be the most fastest way to copy a 2 dimensional
array (rXc) to a range starting at cell A1? Let's say your array's name is ARR. Assuming your array is one-based (not zero-based), then this line of code will do what you asked for... Range("A1").Resize(UBound(Arr, 1), UBound(Arr, 2)) = ARR Rick Rothstein (MVP - Exce) |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy a 2 dimensional array to a range
On 25 oct, 19:27, "Rick Rothstein"
wrote: What would be the most fastest way to copy a 2 dimensional array (rXc) to a range starting at cell A1? Let's say your array's name is ARR. Assuming your array is one-based (not zero-based), then this line of code will do what you asked for... Range("A1").Resize(UBound(Arr, 1), UBound(Arr, 2)) = ARR Rick Rothstein (MVP - Exce) Many thanks. It works ! Avi |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort 2 dimensional Array, copy a row | Excel Programming | |||
| Assigning named range to a 2-dimensional array | Excel Programming | |||
| Insert into a range from a two dimensional array | Excel Programming | |||
| Load excel range into multi dimensional array | Excel Programming | |||
| Transferring part of a multi-dimensional array to a range in VBA | Excel Programming | |||
Linear Mode
