Reading tabs names

[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

 

[Guest]

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.

 

[Don Guillett]

not clear how you want this but

for each ws in worksheets
msgbox ws.name
next ws