You have to delete a name range, then in your formula substitute a name range
to what ever your range is


"KDJ" wrote:

Hello

I am using Excel 2003.

I would like to have "normal" formulas where I am currently using range
names.

How can I restore the cell references i.e. not just get the NAME? error when
the range name is deleted.
--
Thanks very much. KDJ