Working with names

  • Thread starter Thread starter Mauro
  • Start date Start date
M

Mauro

I'm working in a worksheet plenty of named ranges. When I
change a name of a range or cell, the formulas referring
that range don't reflect tha change of the name (they
keep the old name). May you suggest me a procedure to
reflect automatically those changes?
 
No, Excel doesn't change your formulas when you change a name. In fact it doesn't have a "change
a name" feature as such.

You must accomplish that by selecting the range and defining the new name. At that point you
have two named ranges, the original and the new one. Then you would delete the old one from the
Name list.

Then you will have to use Search and Replace to change the name in your formulas.
 
Back
Top