You could get the column numbered with

colNo = Application.Match("ID",Rows(1),0)

and use the column number.


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"T.Vidak" wrote in message
...
Within a macro, instead of selecting the alphanumeric notations for a
column
(i.e. C1,E1) can I use the column title (i.e. ID, Last Updated)? I need to
copy the same three columns over and over again from the Master
spreadsheet
into multiple spreadsheets but the data is not always in the same
positio/column in the Master. Thanks for your help, T.