Named Cell References in VBA
 

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.

Named Cell References in VBA
 

Range("Herman").Value
Range("Herman").Select
etc.

"Michael Excel Dude" wrote
in message m...

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.




--
Michael Excel Dude

Excellent! Thanks. This site is awsome.