sheet tab names

[dave]

Is there a quick way to list all sheet tab names into a
given sheet column for quick reference purposes?

tia,
Dave

 

[Frank Kabel]

Hi Dave
have a look at
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

 

[dave]

thanks - got it!

-----Original Message-----
Hi Dave
have a look at
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

--
Regards
Frank Kabel
Frankfurt, Germany

.

 

[Gord Dibben]

Dave

Sub ShowNames()
Set wkbkToCount = ActiveWorkbook
iRow = 1
With Sheets.Add
For Each ws In wkbkToCount.Worksheets
.Rows(iRow).Cells(1).Value = ws.Name
iRow = iRow + 1
Next
End With
End Sub

Gord Dibben Excel MVP

 

[Norman Harker]

Hi Dave!

For even quicker reference, right click on any of the arrows to the
left of the worksheet tabs. It's also a fast way of navigating to the
sheets if there are a lot of them.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.