TOC: the first page number of each worksheet

[annoni]

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…don’t know anything about the code thingy..Thanks.

 

[Héctor Miguel]

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 D1130 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 __