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