On the other hand...
If "Status" is truly a String Constant then its value will not change.
That is what "constant" means.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"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