Re-name a named range - Please help people!

[I_like_Excel]

Hi there,

I make use of named ranges in Excel. I generally develop a naming convention for the particular spreadsheet model that I am working on, i.e. I would always name a range using a specific format. An example would be "ProfitBeforeTax_IS_A". Anyways, sometimes I change my naming convention, which means I have to go and change the names of named ranges created earlier. Unfortunately I can't figure out how to do this... I would like to change the name of a named range and have Excel automatically update all references to the name. So if I change Range_Name_A to Range_Name_B, Range_Name_A must be deleted and all references to it must be replaced by Range_Name_B.

Thanks!

[jetted]

Hi

Did you try this

Go to tool menu choose insert ------>name ------->define

Thanks
Denis