Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column References
Hi,
How would I reference a range of columns using R1C1 notation. Columns("1:10") , form example, doesn,t work - Rows("1:10") does Thanks and regards, Don Lloyd -- |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column References
Hi Don,
You could try referencing the range using this notation: Range(Cells(1,1),Cells(1,10)).EntireColumn This will select columns 1:10 as per your example. :-) Rob -----Original Message----- Hi, How would I reference a range of columns using R1C1 notation. Columns("1:10") , form example, doesn,t work - Rows ("1:10") does Thanks and regards, Don Lloyd -- . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column References
Thanks Rob
It worked - makes life a lot easier. I still have a feeling that there may be a more direct reference. For example, Columns(10) is a valid reference. Don -- "Rob Barnard" wrote in message ... Hi Don, You could try referencing the range using this notation: Range(Cells(1,1),Cells(1,10)).EntireColumn This will select columns 1:10 as per your example. :-) Rob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Alpha column references | Excel Discussion (Misc queries) | |||
Alpha column references | Excel Discussion (Misc queries) | |||
how to change column references, while filling down another column | Excel Discussion (Misc queries) | |||
Row and Column References | Excel Discussion (Misc queries) | |||
Variable Column references | Excel Worksheet Functions |