View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Charlotte Howard Charlotte Howard is offline
external usenet poster
 
Posts: 37
Default Page numbering - grouped worksheets

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