View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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