Worksheet relative reference

[FredMcStaire]

Is there a formula, no VBA please, that can return the relative position of a worksheet in a workbook? For example, the formula would return a "2" when pointed at the second tab, and a 10 when pointed at the 10th?

Thanks

 

[Firefly2012]

Hi

You can using an old XLM4 macro function:

1. Create a name (Formulas>Define Name in xl2010) and call it ShtNum
2. In the refers to dialog write:

=GET.DOCUMENT(87)+NOW()-NOW()

Back in the document, type

=ShtNum

into your sheet. It will return the index position of the sheet (including Hidden Sheets it would appear).

 

[FredMcStaire]

Works like a charm! Thanks!