Named Constant
Try this:
To get the value:
Names("Status").RefersTo
To set the value:
Names("Status").RefersTo = "OFF"
Does that help?
Post back if you have more questions.
--------------------------
Regards,
Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
"Shatin" wrote in message
...
Hi All,
If I have a named constant in a certain worksheet called "Status" whose
inital value is "On". What's the vba code for:
- finding out what the value of this named constant is?
- changing the value to "Off" if the value is "On"?
TIA
|