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
|