Insert|Name|Defind

Names in Workbook: Sige
refers to: =indirect("a1:a10")

may work for you.

Sige wrote:

Hi there,

I would like to create a Defined NAME: eg. a1:a10 =sige which is
relative to the sheet.
So when having the formula sum(sige) on sheet1 it will give me the
result of Sheet1!a1:a10
& on sheet2 it will return me the result of sheet2!a1:a10

Creating the name as: !a1:a10 (without the sheet name) is not a
solution is it?

Thanks for your insights, Sige

--

Dave Peterson