ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   pagenumber etc. (https://www.excelbanter.com/excel-programming/314070-pagenumber-etc.html)

hans[_3_]

pagenumber etc.
 
Has somone a function that can display a pagenumber and/or the total number
of pages te print.

Thanks Hans



Ron de Bruin

pagenumber etc.
 
Hi Hans

pagenumber

is possible but very slow


the total number


Sub test()
Dim TotPages As Long
TotPages = Application.ExecuteExcel4Macro("GET.DOCUMENT(50)")

MsgBox TotPages
End Sub



--
Regards Ron de Bruin
http://www.rondebruin.nl


"hans" wrote in message ...
Has somone a function that can display a pagenumber and/or the total number of pages te print.

Thanks Hans





All times are GMT +1. The time now is 10:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com