Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named cells in an array to a column and to a row
All the code works in the macro that this excerpt is from, so I did not include the entire macro.
The .Resize(columnsize:... puts the named cells values in a row just fine. The .Resize(rowsize:... puts the first named cell value ONLY in ALL the cells in the column. So I get a column of nine values that is in cell AAAA2. What gives with this?? Thanks. Howard Set myRng = wksSource.Range("AAAA2,AAAA4,FFFF2,GGGG4,NNNN2,OOO O4,VVVV20,XXXX8,XXXX20") With wksSource wksTarget.Range("C2").Resize(columnsize:=myRng.Cel ls.Count) = myArr wksTarget.Range("B2").Resize(rowsize:=myRng.Cells. Count) = myArr End With |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting a column of a 2D array = named range | Excel Programming | |||
Selecting all the active cells in a named column. | Excel Worksheet Functions | |||
Moving many named cells at once to the next column | Excel Worksheet Functions | |||
DIFFERENT NAMED CELLS IN COLUMN,HOW DO I GET LAST ONE ON BOTTOM? | Excel Worksheet Functions | |||
Possible to reference column of named range in array formula? | Excel Programming |