MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Number of pages in print

Posted by Carli Feller on July 19, 2001 12:35 PM

In a macro that I wrote I need to know how many page i have if i print my worksheet.
May be exist a variable with this data?
Thanks ,Carli

Posted by Ivan F Moala on July 19, 2001 7:11 PM

Sub GetNoPgs_toprnt()
Dim pages 'As Double
pages = ExecuteExcel4Macro("GET.DOCUMENT(50)")
MsgBox pages & " Pages will be printed"

End Sub