Using names in a formula

[uivandal]

I have created a formula that references a cell on another tab and after the formula was created, named the cell on the other tab. Is there a quick way to update my formula to list the name, not the cell on the other tab? Thank you for your help.

 

[Luke M]

Other than doing a *careful* find and replace, I don't think so.

 

[uivandal]

Oh well. Thank you for the reply.

 

[NARAYANK991]

Hi ,


Can this help you ?


http://excelribbon.tips.net/T008266_Applying_Range_Names_to_Formulas.html


Narayan


P.S. There seem to be problems in applying names if your formulae contain Sheet references ; thus if a cell reference alone is used in a formula , it is replaced by its range name , but if the Sheet reference is also included in the formula , then Apply Names does not seem to work.

 

[uivandal]

For some reason that is not working for me.