name box

[RichardO]

Hello All:

Is there a way I can rename an existing named range (in a name box)?

Thank you for your kind help.


RichardO

 

[Jason Morin]

Not that I know of. You have to go through the menu
(Ctrl+F3).

HTH
Jason
Atlanta, GA

 

[Bob Phillips]

You can't rename, just add (and delete of course)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[RichardO]

Thanks, Jason, that worked

 

[Charles Williams]

Be careful:

- changing the name in the define name name dialog and pressing enter
generates a new name.
- if you then delete the old name any reference to the old name in formulae
and charts etc will give a #Name Error

regards
Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm