Page x of y in WorkBook

[Trainer]

Using Excel 2007 on Windows XP. We have 3 worksheets with 10 pages each.
We want the total pages in the workbook. For example, Page 1 of 30, Page 2
of 30, etc. I tried grouping the 3 worksheets but that didn't give me the
result I want. Can this even be done? Most stuff can, if you just know
how. Thanks for any ideas.

 

[Gord Dibben]

That's how I would do it.

Select all three sheets and set up your footer as page 1 of ?.

Print as one print job using ActiveSheet(s)


Gord Dibben MS Excel MVP

 

[Trainer]

How simple is that!! Thanks it worked perfectly.

Trainer