There is a template in Excel called Loan Amortization. It uses many
named ranges. I want to create a copy of the original sheet in the
same workbook so I want to change the scope of all of the named ranges
from global (workbook) to local (worksheet). I was able to change the
scope for 25 out of 29 of the names but it doesn't work for the
remaining four which a Int_Rate, Loan_Amount, Loan_Start, and
Loan_Years. Does anyone know why?