Developing a contents page using the tab headings

U

Una

Hi

Does anybody know how you can develop a contents worksheet
tab that details all the tabs within the workbook? I know
this is a lazy option to writing the tab headings but
there are quite a number of tabs in this workbook and if
headings change I would like this to update the contents
worksheet. I know you can see this in properties but I
would like to be able print this.

Many thanks

Úna
 
D

Don Guillett

try this for column A list

Sub tablist()
Columns(1).ClearContents
For Each ws In Worksheets
Cells(i + 1, 1) = ws.Name
i = i + 1
Next
End Sub

--
Don Guillett
SalesAid Software
[email protected]
Hi

Does anybody know how you can develop a contents worksheet
tab that details all the tabs within the workbook? I know
this is a lazy option to writing the tab headings but
there are quite a number of tabs in this workbook and if
headings change I would like this to update the contents
worksheet. I know you can see this in properties but I
would like to be able print this.

Many thanks

Úna
 
D

DDM

Una, you might want to take a look at this page from David McRitchie's
Website: http://www.mvps.org/dmcritchie/excel/buildtoc.htm.
--
DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com


Hi

Does anybody know how you can develop a contents worksheet
tab that details all the tabs within the workbook? I know
this is a lazy option to writing the tab headings but
there are quite a number of tabs in this workbook and if
headings change I would like this to update the contents
worksheet. I know you can see this in properties but I
would like to be able print this.

Many thanks

Úna
 
Top