Hi
maybe the following site will help you
http://www.tushar-mehta.com/excel/so...toc/index.html

Frank

Hi Everyone,

I have a workbook that has 28 sheets. This workbook is meant to be
printed out. Several of the sheets run for more than one page. For
example, sheet 5 may be made up of 3 pages. Because the information
is pulled from a database automatically, the number of pages per
sheet
varies.

I would like to create a dynamic TOC that counts the pages of each
sheet and displays it. For example:

Contractors ..............................pages 10-15
Vendors....................................pages 16-18

And so on. Anyone have any ideas of an easy way to do this?

Thanks!

Frankie


---
Message posted from http://www.ExcelForum.com/