Each worksheet can have multiple pages to print...
So I don't understand what page number would be entered
next to the sheet name.
In any case, you may want to give the free Excel add-in "Excel Extras" a try.
It creates a Table of Contents sheet that lists every sheet in the workbook.
Each sheet name is hyperlinked to the sheet. Next to the sheet name is the
number of printable pages for that sheet.
If that interests you it can be downloaded from...
http://www.realezsites.com/bus/primitivesoftware
It does other stuff too...sorting sheets and setting / reading print areas
and more.
--
Jim Cone
San Francisco, USA


"pkeegs"

wrote in message
I want to add a contents page to a workbook. When I group the worksheets to
print I want the page number of each sheet to be inserted automatically in a
cell in the contents page alongside the sheet title. At the present I am
inserting the page number manually. Can I do it?