Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I thought I'd done this in the past, but I can't remember if or how. I
want be able to assign an array of values to a range in 1 go, such as 1 2 3 4 5 6 7 8 9 to A1:C3 I'd thought I'd done something like Range("A1:C3") = (1,2,3;4,5,6;7,8,9) using ; as a delimiter between rows in the array, but that clearly isn't working. I'm quite familiar with the looping/iterator techniques available to assign a variable array to a range. I was just hoping there was a way to do this in one line of code. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Reference array constant values in a formula | Excel Discussion (Misc queries) | |||
Assign Values to array | Excel Discussion (Misc queries) | |||
Excel 2003. Assign array to range | Excel Programming | |||
HOW TO ASSIGN 2 DIMENSION ARRAY VALUES FROM 2 COLUMNS? | Excel Programming | |||
How do I assign values to an array? | Excel Programming |