D Dominic Robinson Sep 11, 2003 #1 Is there any property of the worksheet or workbook object that will tell me the number of pages that will be printed?
Is there any property of the worksheet or workbook object that will tell me the number of pages that will be printed?
D Don Guillett Sep 11, 2003 #2 will this work? Sub countpb() MsgBox ActiveSheet.HPageBreaks.Count End Sub
R Ron de Bruin Sep 11, 2003 #3 Try this Sub test() Totpage = Application.ExecuteExcel4Macro("GET.DOCUMENT(50)") MsgBox Totpage End Sub
Try this Sub test() Totpage = Application.ExecuteExcel4Macro("GET.DOCUMENT(50)") MsgBox Totpage End Sub
