Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Named Range Scope
Excel 2007, New, Loan Amortization (Template),
Select cell D5 Unprotect Sheet, Name Manager, Loan_Amount, Delete, Ok New, Name: Loan_Amount, Scope: Loan Amortization Schedule, Ok, Close It appears that I can change the scope of all names in this workbook from global to local except Int_Rate, Loan_Amount, Loan_Start, and Loan_Years. How come? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Range Name Scope | Excel Discussion (Misc queries) | |||
Deleting all named ranges that have a workbook scope | Excel Discussion (Misc queries) | |||
Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
Scope of range names | Excel Discussion (Misc queries) |