Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
What is the syntax for copying a VBA array into a range of cells?
I know I can copy into each cell individually in a for-loop. I am wondering if there is a way to do it en masse in a single statement. For example: dim xdata(10) as variant for i = 1 to 10: xdata(i-1) = i: next i range("a1:a10") = xdata That does not work the way that I want. It copies xdata(0) into each of A1:A10 instead of copying xdata(1) into A2, xdata(2) into A3, etc. I want the latter. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy a range into an array | Excel Programming | |||
copy one array formula to an array range | Excel Programming | |||
efficiently copy values from a Range of cells to an array (in VB.N | Excel Programming | |||
efficiently copy values from a Range of cells to an array (in VB.N | Excel Programming | |||
How Can I copy all value of the array into the range? | Excel Programming |