MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How to Edit a Formula Used to Specify a Cell Range Name


Posted by oeloel on August 04, 2000 8:53 PM

Hi everyone! Is there a way to edit a formula that I used to specify a range name in ExcelÂ’97? Thanks.


Posted by oeloel on August 05, 0100 7:29 AM

Celia, Does your approach act on a formula that I used in tha menu Insert - Name - Define, a name that I then used in a pivot table? Thanks.

Posted by Celia on August 05, 0100 4:31 PM

That's right. You can, of course also do it manually.

Posted by Celia on August 04, 0100 11:58 PM


oeloel
I presume that you want to edit with VBA.

If the name is presently called "MyName" then to replace the formula :-

ActiveWorkbook.Names.Add Name:="MyName", RefersTo:="=YourNewFormula"

Celia