One method

In sheet1 insertnamedefine

myrange

refers to =INDIRECT(A1:A10)

Note: you will not see this name in the namebox.

To access hit F5 and type in myrange

But you can use it in formulas like =SUM(myrange) for whatever sheet is
active.


Gord Dibben MS Excel MVP


On Mon, 9 Nov 2009 08:20:01 -0800, Gant
wrote:

I'm trying to copy an excel template that has naming references included.
Is there a way to copy the template to a new worksheet within the existing
spreadsheet, but have the naming references be relative (pointing to the
current worksheet) as opposed to absolute (pointing to the previous
worksheet)?