How to change Name and update dependent cells?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Don Culp - 10 Nov 2006 10:05 GMT

I have a cell with a constant named X. How can I want to change
this name to N and automatically have all other cells that had previously
referred to X now refer to N?

Excel 97

Thanks,
Don Culp

Reply to this Message

Niek Otten - 10 Nov 2006 10:10 GMT

Hi Don,

Download Jan Karel Pieterse's Name Manager:

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

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have a cell with a constant named X. How can I want to change
| this name to N and automatically have all other cells that had previously
[quoted text clipped - 4 lines]
| Thanks,
| Don Culp

Reply to this Message