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
|