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 Excel97? 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
