Dan Beard

Have you tried InsertNameDefineadd? Here you can delete the old and add
a new Named range.

Mike Rogers

"Dan Beard" wrote:

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