Named Cell References in VBA

M

Michael Excel Dude

I'd like to be able to refer to the 'name' of a cell, rather than it's
location, in VBA macro code. This way, if I move the cell, the macro
will know where to look for the value.

Can anyone help?

Thanks.
 
M

Michael Excel Dude

Bob said:
Range("Herman").Value
Range("Herman").Select
etc.

"Michael Excel Dude" [email protected]
wrote
in message
I'd like to be able to refer to the 'name' of a cell, rather than
it's
location, in VBA macro code. This way, if I move the cell, the macro
will know where to look for the value.

Can anyone help?

Thanks.
Click to expand...


Excellent! Thanks. This site is awsome.
 
Top