Absolute worksheet referencing

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

Hi all,

I would like to be able to reference a specific worksheet within a function (such as
"SomeSheet_1!$O$6") regardless of any changes a user makes to the sheet's name (on the sheet tab).
The number of cells involved is > 30 on 3 different sheets so defining Names doesn't look so
appealing. Is there a way to absolutely reference a worksheet within an Excel function?

Thanks,

Bob
 
Bob said:
I would like to be able to reference a specific worksheet within
a function (such as "SomeSheet_1!$O$6") regardless of any changes
a user makes to the sheet's name (on the sheet tab).
Click to expand...
....

Worksheets are always 'absolute' references in Excel. As long as you're
using 'direct' references, e.g.,

='foo bar'!X99

rather than indirect references using INDIRECT(), any changes users make in
worksheet names will automatically be made to all references to those
worksheets. That said, if you need to ensure a certain structure, protect
worksheets and the workbook. It's not foolproof, but it'll prevent the
honest & naive from screwing things up.
 
Back
Top