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
|