View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default Modifying a Defined Name's Contents

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.

--
Garry

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