Get number of pages for printing from Excel Intero

Question

How can I programatically retrieve the number of pages a workbook or worksheet will print to from the Excel 2007 Interop (Microsoft.Office.Interop.Excel)?

Answer 1

are you looking for ActiveSheet.PageSetup.Pages.Count?

Answer 2

Just use

"ActiveWindow.SelectedSheets.PrintOut From:=1, To:=1, Copies:=1, Collate:=True, IgnorePrintAreas:=False"

Change "From" and "To" to your pages.

Answer 3

PageSetup.Pages.Count will give the correct answer. But how to fetch the correct count if comments are printed at end of sheet.