Reading tabs names
 

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

Reading tabs names
 

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.
--
Gary's Student


"smaruzzi" wrote:

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

Reading tabs names
 

not clear how you want this but

for each ws in worksheets
msgbox ws.name
next ws
--
Don Guillett
SalesAid Software

"smaruzzi" wrote in message
...
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