The main purpose of TOC is to print hardcopy of table of contents with page
numbers€¦so I do not need hyperlink with worksheet names or what not€¦

I have about 20 worksheet in a file and like to make a worksheet that
contains the number of the first page of each worksheet.---I am numbering
entire worksheet continuously. TOC worksheet should not be included in
paging. I prefer the TOC within the file but if not possible, in a separate
file would be ok. Please help..

If it has to be the code thing,, please be kind and provide step by step
details€¦dont know anything about the code thingy..Thanks.

hi, !

what you need could suffer variations depending on non/controled events
(i.e. changing printer/resolution/quality/pint area-titles/... and so on) so...

where *exactly" do you need the numbers in your TOC-sheet ?
(i.e. in range D11:D30 or... ???)

regards,
hector.

otherwise, you could seek alternates like in the following pages:

Build Table of Contents, similar listings, working with Hyperlinks
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

Build TOC Another Approach
http://www.mvps.org/dmcritchie/excel/buildtoc2.htm

__ OP __
The main purpose of TOC is to print hardcopy of table of contents with page numbers
so I do not need hyperlink with worksheet names or what not
I have about 20 worksheet in a file and like to make a worksheet that contains
the number of the first page of each worksheet.
I am numbering entire worksheet continuously.
TOC worksheet should not be included in paging.
I prefer the TOC within the file but if not possible, in a separate file would be ok...