Get number of pages for printing from Excel Interopb

How can I programatically retrieve the number of pages a workbook or workshe开发者_StackOverflow中文版et will print to from the Excel 2007 Interop (Microsoft.Office.Interop.Excel)?

---

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

---

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

---

Just use

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

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