@ p45cal. I have a follow up question. Is there a way to make this code do the job, when the precedence is a relative defined name? (See the excel attachment. I have defined a relative name (“inflation”) and when in cell “E1”and enter 1 in the input box, I expect to go “E2”.)
|