Select column same row by range name
 

I want to use a range name in a macro so I can change the column referenced
without changing the macro.

What I need to do in the macro is select a cell on the same row but within a
range named column. Say the name for the column is "bank", can someone give
me the syntax?

Thanks

Select column same row by range name
 

Not sure, but something like:
Range("bank").Offset(0,10).select
Selects a cell in same row as "bank", but 10 columns to the right.

NickHK

"Kevryl" wrote in message
...
I want to use a range name in a macro so I can change the column
referenced
without changing the macro.

What I need to do in the macro is select a cell on the same row but within
a
range named column. Say the name for the column is "bank", can someone
give
me the syntax?

Thanks