Excel Help – Sheet Indexes

Trying to get a specific cell on each worksheet to display its unique index number (1, 2, 3 etc.)

So far I have “=sheetnum()” in the cell with the module…

Function SheetNum() As Integer
SheetNum = ActiveSheet.Index
End Function

This always shows the index number of the last active sheet, so assuming that the “activesheet” bit needs to change – or am I way off/over-thinking things?

What have we become eh?

😛

Slow day!!

You need to pass it a cell or range from the WS eg:

Public Function SheetIndex(ByRef Cells As Range) As Integer

SheetIndex = Cells.Worksheet.index

End Function

Called by =sheetindex(E32) in a cell

The E32 is irrelevant, just use any cell in that sheet

Perfect, thanks 🙂