Developing a contents page using the tab headings

  • Thread starter Thread starter Una
  • Start date Start date
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
 
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
 
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
 
Back
Top