Hi

You can use an UDF. The one below returns tab name from tab's index (order
number)

---------
Public Function TabByIndex(TabIndex As Integer) As String
Application.Volatile
TabByIndex = Sheets(TabIndex).Name
End Function
---------

P.e.
=TABBYINDEX(3) returns the name of 3th sheet in your workbook


Arvi Laanemets


"JF Bouthillier" wrote in message
...

Hi all,

Is there a simple way to list the worksheet names into
cells?

Thank you.
JF