Reading tabs names

S

smaruzzi

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
 
G

Gary''s Student

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.
 
D

Don Guillett

not clear how you want this but

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