If Range(Variable_1) = "Blah" 'Spaces not allowed in named ranges
or
If [Variable_1] = "Blah"
HTH
Charles
Sandy wrote:
How can I address via vb the value stored in a named range cell.
example: on worksheet 3 I have a cell named variable 1
I want to retrive the value from that cell without going to it and selecting
it. Is there a way?
Thanks