Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
insert page breaks
I have a worksheet in which I add a number of charts via vba. The number of
charts added changes (eg may be 6 or 20 or more) depending on my data. The arragement on the page is 2 x n where there are 2 across the page that fit the print area. How do I find the bottom of each page so that I can insert the required page breaks into the worksheet with the following or something else; ActiveWindow.SelectedSheets.HPageBreaks.Add Befo=ActiveCell Bruce |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel: how to insert page breaks between all the rows at once? | Excel Discussion (Misc queries) | |||
How do I insert page breaks in .txt for use in excel? | Excel Discussion (Misc queries) | |||
Insert Multiple Page Breaks | Excel Worksheet Functions | |||
insert page breaks | Excel Programming | |||
insert page breaks every 43 lines | Excel Programming |