View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bill Kuunders Bill Kuunders is offline
external usenet poster
 
Posts: 303
Default Selecting Columns by Title

You could name the columns. <Insert<name<add
for instance RCcolumn refers to D:D
and then use the line

Application.Goto Reference:="RCcolumn"


--
Greetings from New Zealand
Bill K
"Jessica" wrote in message
...
I am writing a macro to select columns based on their title.

If I always wanted to select Column D, then I could use:
Columns("D:D").Select

But in my case, I want to select a column that is titled "RC". I tried to
replace "D:D" with "RC", but I get an error.

Thanks,
Jessica