ExcelBanter - relative defined name references?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - relative defined name references? (https://www.excelbanter.com/excel-discussion-misc-queries/247948-relative-defined-name-references.html)

relative defined name references?

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)?

relative defined name references?

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)?