Rename name so formulas show name change

[John]

Excel 2003

Cell A1 is named MyCell.
Cell A2 has formula "=MyCell".

I rename cell A1 in the toolbar to NewCell.
Cell A2 still has the formula "=MyCell".

How do I rename cell A1 to NewCell and have
it automatically change cell A2 to the formula "=NewCell"?

Thank you for your help.

 

[Niek Otten]

Download Jan Karel Pieterse'e Name Manager here:

http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.asp

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Excel 2003
|
| Cell A1 is named MyCell.
| Cell A2 has formula "=MyCell".
|
| I rename cell A1 in the toolbar to NewCell.
| Cell A2 still has the formula "=MyCell".
|
| How do I rename cell A1 to NewCell and have
| it automatically change cell A2 to the formula "=NewCell"?
|
| Thank you for your help.
|
|

 

[John]

Niek

Thank you for the link to Name Manager.
It does exactly what I need!

John

 

[Guest]

Following is what Microsoft have to said about Changing and Deleting a Define
Name.

====================================================
Change or delete a defined name
On the Insert menu, point to Name, and then click Define.
In the Names in workbook list, click the name you want to change.
Do one of the following:
Change the name
Type the new name for the reference, and then click Add.
Click the original name, and then click Delete.
Change the cell, formula, or constant represented by a name
Change it in the Refers to box.

Delete the name
Click Delete.

=====================================================

According to me, after renaming a Name, you have to manually change each and
every formula. After changing a name, I always use Find and Replace command
for changes to take effect.