TOC: the first page number of each worksheet

  • Thread starter Thread starter annoni
  • Start date Start date
A

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.
 
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 __
 
Back
Top