Developing a contents page using the tab headings

[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

 

[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
(e-mail address removed)
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

 

[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