| 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 |
| 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 | |||
Threaded Mode
