If you have to localize (or globalize) and existing name, you'll want to use Jan
Karel Pieterse's (with Charles Williams and Matthew Henson) Name Manager:
NameManager.Zip from
http://www.oaltd.co.uk/mvp
In fact, if you're working with names, you'll want this!
Gee wrote:
I named my ranges using the "create from selection Tab" . I was not under the
impression that thisd defaults the scope of the name to the full workbook. I
have done many ranges this way and have used these in formulae. I need to
change the scope to the worksheet , and I dont want to have to redo the whole
sheet because of this .
How do I quickly change the scope of the range names ? I have tried it
through the Name manager but the scope is Greyed out.!!!
Please HELP ME anyone !!!!
GEE
--
Dave Peterson