Selecting multiple columns
Columns(1).Resize(,3).Select
Range(Columns(1),Columns(3)).Select
Are two ways.
--
Regards,
Tom Ogilvy
"Kiloran" wrote in message
...
I can select Column A with either Columns("A").Select or Columns(1).Select
I can select Columns A-C with Columns("A:C").Select. However,
Columns(1:3).Select does not work.
How can I select a range of columns using a numeric reference?
--Alan
|