Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hey All,
I have a set of 500 or so numbers that i want to use for debugging. These numbers are in matrix form (30 rows) x (18 cols) and i need to hard code these numbers into cells for debugging. I would like to insert these values into a range of the same size ( Range("B2:S31")) is there a easy way of doing this? sorta like Range("B2:S31") = [1 , 2, 3, 4......] i've tried the same thing with populating a multidimensional array and the only way i can do it is to write one line of code per element of the array.Can anybody help me with this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Populating a range from tab b into tab a | Excel Worksheet Functions | |||
populating a cell will a value from a range of cells | Excel Programming | |||
Populating a range | Excel Programming | |||
Populating a Range by Code | Excel Programming | |||
Populating a Named Range... | Excel Programming |