Page numbering - grouped worksheets

  • Thread starter Charlotte Howard
  • Start date
C

Charlotte Howard

Hello,
When I use Page &[Page] of &[Pages] to print the page number of a work
sheet, it works fine if I print off one worksheet ( ie page 1 of 6).

But if I select 3 worksheets, it then prints as Page 1 of 18.

These worksheets will be statements, going out to multiple people who only
want to see Page 1 of 6 on their statements, not Page 1 of 180! They would
wonder where the remaining 174 pages went.

Is it possible to do this?
Excel 2003

Thanks
 
Top