Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The first line works fine to set the block of cells...
Why won't the 2nd line work? (results are all cells are blank, the "1"'s all get wiped out) Range("F3:H6").Value = "1" Range("F3:H6").Value = Array(Array("1", "2", "3"), Array("4", "5", "6"), Array("7", "8", "9"), Array("10", "11", "12")) 2nd line should all be on 1 line in the VBE; I also tried making the data just integers... Array(1,2,3).... but that did the same thing. What is the best/better way to assign a user-type module level multidim array to a contiguous block of cells? Using a loop to scroll through the 2 dimensions and assigning each value to a cell (via range.offset.value) sure seems slow (even with screen updating off and calculation off) Is there a way to set up the definition of an array that can be directly assigned to a range of cells? I.E: [F3:H6] = myarray Where myarray matches the cell blocks in dimension. -- Regards, John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
problem assigning range returned by function, to combobox rowsource | Excel Programming | |||
Assigning ranges for values (e.g., $1,005 the range is ">$1K to 5K | Excel Worksheet Functions | |||
problem with Paste-Special-Values from a List (range of cells) | Excel Programming | |||
Problem with assigning values to items in collection | Excel Programming | |||
Assigning values from a selected range to individual variables | Excel Programming |