View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dan Beard[_2_] Dan Beard[_2_] is offline
external usenet poster
 
Posts: 3
Default Changing a Defined Name

Hi,

Wonder if anyone can help with this...

I've created a Name for a range of cells which I use in various formulas
elsewhere within my Workbook but I now want to change that Name - i.e.
instead of reading 'USDGBPROE2008' I want it to read 'USDGBPROE2007'
I don't want to change the cells it relates too or its use in the formulas.
I can't edit / replace as the formulas lose the link.
Is it possible just to change the name anywhere?

Thanks in advance
DB