| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
determine range for printed pages
The following code returns the page count for printed pages - Is it
possible to also find out the range for each page which will be printed, based on this page count? PageCount = 0 For Each sht In Worksheets sht.Activate Pages = ExecuteExcel4Macro("Get.Document(50)") PageCount = PageCount + Pages Next sht MsgBox "Total Pages = " & PageCount tia, dk |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
determine range for printed pages
hi, dk !
The following code returns the page count for printed pages Is it possible to also find out the range for each page which will be printed, based on this page count? PageCount = 0 For Each sht In Worksheets sht.Activate Pages = ExecuteExcel4Macro("Get.Document(50)") PageCount = PageCount + Pages Next sht MsgBox "Total Pages = " & PageCount AFIAK, for each 'sht' it should be the usedrange.address... unless, you have a customized printarea, printtitlerows/columns, ??? where you would need to find out through each 'sht' pagesetup properties hth, hector. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| number of pages will be printed | Excel Discussion (Misc queries) | |||
| Printed multiple pages per sheet | Excel Discussion (Misc queries) | |||
| i would like that my first line to appear in all printed pages | Excel Discussion (Misc queries) | |||
| Excel 2003 - Determine the number of printed pages | Excel Programming | |||
| headers across printed pages | Excel Worksheet Functions | |||
Linear Mode
