| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pages
Is there any property of the worksheet or workbook object
that will tell me the number of pages that will be printed? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pages
will this work?
Sub countpb() MsgBox ActiveSheet.HPageBreaks.Count End Sub "Dominic Robinson" wrote in message ... Is there any property of the worksheet or workbook object that will tell me the number of pages that will be printed? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pages
Try this
Sub test() Totpage = Application.ExecuteExcel4Macro("GET.DOCUMENT(50)") MsgBox Totpage End Sub -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Dominic Robinson" wrote in message ... Is there any property of the worksheet or workbook object that will tell me the number of pages that will be printed? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number of pages in worksheet doesn't match Print Preview pages | Excel Discussion (Misc queries) | |||
| How do I delete pages in Excel? Keeps printing blank pages at end. | Charts and Charting in Excel | |||
| Need Help -- Baseball stats in excel only has 23 pages--Need to addmore pages.. | Setting up and Configuration of Excel | |||
| Need Help -- Baseball stats in excel only has 23 pages--Need to addmore pages... | Excel Worksheet Functions | |||
| How do I delete pages from an Excell template of mutiple pages | Excel Discussion (Misc queries) | |||
Linear Mode
