| 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? |
| Reply |
| 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) | |||
Linear Mode
