GS laid this down on his screen :
on 9/20/2011, nntp.aioe.org supposed :
Garry,

I appreciate the tremendous amount of code in your response.

After going over it with my limited coding skills, I haven't been able
to extrapolate the parts that would allow me to modify a defined name's
Refers to: field.



- Ronald K.

Ronald,
In the section following this comment...

'Persist any changes the user makes during runtime

..you'll find code examples to both read/write a defined name's RefersTo.
Reading a value uses Evaluate(); writing the value uses the '=' operator same
as any other value.

Just to be clear.., the defined names in my example have local scope
and so belong to the worksheet names collection...

ActiveSheet.Names("<name").RefersTo = "<value"



If your defined name has global scope then...

ActiveWorkbook.Names("<name").RefersTo = "<value"

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc