View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Range Name Scope

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