Hi Ron,

Thanks for your pointer. As it happens Charles Williams replied to my post,
so I've got it straight from the horse's mouth so to speak (no offense
Charles!).

Thanks to you both.

John

"Ron de Bruin" wrote in message
...
Hi John

Contact JK about this

See his website for a mail address

--
Regards Ron de Bruin
http://www.rondebruin.nl


"John" wrote in message
...
Hi there,

I've been trying out Jan Karel Pieterse's Name Manager add-in
(http://www.decisionmodels.com/downloads.htm#namemanager) which seems to
work very nicely, but I have a question: The add-in has a function to
convert a Name from Global to Local and vica-versa and when you convert
to local the name changes from:

"Bob" (RefersTo Sheet1!$E$7)

to

"Sheet1!Bob" (RefersTo Sheet1!$E$7)

That's fine, but the name in the drop down box (to the left of the
address bar) continues to show "Bob". So my question is, is how can you
retreive that name ("Bob") in code as both .Name and .NameLocal return
"Sheet1!Bob"?

(The context to this is that I'm converting all names with formulas to
cell references.)

Best regards

John