Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Range Name Scope
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I change a Name scope from local to Global? | Excel Discussion (Misc queries) | |||
Change scope of a name | Excel Discussion (Misc queries) | |||
Scope of Variables | Excel Discussion (Misc queries) | |||
How can I change a Name scope from local to Global? | Excel Discussion (Misc queries) | |||
Scope of range names | Excel Discussion (Misc queries) |