View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sige
 
Posts: n/a
Default Defined name Relative to sheets

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