sheet number

  • Thread starter Sheets number position
  • Start date
S

Sheets number position

how do i return the sheet number position. something that would return the
value of 3 if it is the third sheet in a workbook of 5 sheets.
 
J

JMB

you could use a user-defined function. insert a vba module in your workbook
and paste the following code:

Function SheetIndex() As Long
Application.Volatile True
SheetIndex = Application.Caller.Parent.Index
End Function

to use enter =sheetindex() into a cell.
 
Top