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

--

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

--



.

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