Group all the sheets you want to check then use print preview,
if you are showing the page number on the printed pages you will see the total on the last page.

Don't forget to ungroup your sheets when finished or risk severe damage to your workbook
as any change made to a grouped sheet is made to all sheets in the grouped sheets.

To group sheets, select first sheet then hold shift and select last sheet, or right click
on sheet tab and choose select all sheets.

to UNGROUP sheets when finished, right click on sheet tab and choose Ungroup Sheetsl

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"RP2chil" wrote in message ...
I have a huge excel worksheet and I want to determine how many pages it will
be. Is there a way to do that?

I also have separated this document into 8 or 9 worksheets.

Thanks.
--
- RP -