B
Bob Umlas, Excel MVP
Couldn't reply, so posting as new!
Write a Function, in VBA like:
Function tabName(idx As Integer) As String
tabName = Sheets(idx).Name
End Function
(Alt/F11; then Insert/Module. then put in the above).
In the worksheet, enter
=TABNAME(ROW(A1))
and fill down for as many sheets as there are.
Write a Function, in VBA like:
Function tabName(idx As Integer) As String
tabName = Sheets(idx).Name
End Function
(Alt/F11; then Insert/Module. then put in the above).
In the worksheet, enter
=TABNAME(ROW(A1))
and fill down for as many sheets as there are.