| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how can I count the vertical pages of a print job?
I am trying to write some code where I am trying to stay within the one page
width by however many pages long. I don't like Excel's automatic page set-up because sometimes it doesn't maximize the printed page space so I have done the following ... i = 10 ActiveSheet.DisplayAutomaticPageBreaks = True ActiveSheet.PageSetup.Zoom = i 'keep going up til 1 then drop back down one Do Until ActiveSheet.VPageBreaks.Count = 1 i = i + 1 ActiveSheet.PageSetup.Zoom = i Loop i = i - 1 ActiveSheet.DisplayAutomaticPageBreaks = False Do you have any ideas as to why my code doesn't work? It appears I am not using the vpagebreaks properly ... any ideas .... ? Thank you !! |
| 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 print pages of pages example (1of3) | Excel Discussion (Misc queries) | |||
| How to print odd pages and even pages seperately in Excel. | Excel Discussion (Misc queries) | |||
| How do I not print or count pages? Excel97 | Excel Programming | |||
| Can I print only specified pages from a print range such as pages 1,3,4,6 | Excel Programming | |||
Threaded Mode
