Pages

  • Thread starter Thread starter Dominic Robinson
  • Start date Start date
D

Dominic Robinson

Is there any property of the worksheet or workbook object
that will tell me the number of pages that will be
printed?
 
will this work?

Sub countpb()
MsgBox ActiveSheet.HPageBreaks.Count
End Sub
 
Try this

Sub test()
Totpage = Application.ExecuteExcel4Macro("GET.DOCUMENT(50)")
MsgBox Totpage
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Print entire workbook with each sheet starting at page 1 8
Macro to print specified range of several work sheets 2
Method to automate page numbers on single worksheet 1
Print Entire Workbook 6
Excel Fit to page print options in Excel 1
Honoring page setup of each worksheet 2
Userform to Select what worksheets to print 1

Back
Top