How do I not specify the sheet when defining names?

  • Thread starter Thread starter Graham Long
  • Start date Start date
G

Graham Long

Hi,

I know there's a way to do this, but I can't remember.

What I want to do is name a range without specifying the sheet so that any
formula on any given sheet knows that name refers to the range on that same
sheet.

I thought it was ~![cell], but that doesn't seem to work and I can't find a
reference to it anywhere.

Thanks,

Graham
 
Graham

If you set the Refers To value to =!$A$1 the name will refer to
cell A1 on whichever sheet is active.

Note the !

Also note: your name won't show up in the name box.

Gord Dibben XL2002
 
Back
Top