Reading tabs names

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to go thru the list of tabs, and read their names from within
a cell?
Is there a function to do that?

Thanks, Stefano
 
The following function:

Function tabname(i As Integer) As String
If i > Worksheets.Count Then
tabname = ""
Exit Function
End If
tabname = Worksheets(i).Name
End Function

will return the name of the i th worksheet. For example:
=tabname(3)
will return the name of the third worksheet.
 
not clear how you want this but

for each ws in worksheets
msgbox ws.name
next ws
 
Back
Top