ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Force Page Break on Subtotals to Odd Page (https://www.excelbanter.com/excel-discussion-misc-queries/205845-force-page-break-subtotals-odd-page.html)

Jim Sheehan

Force Page Break on Subtotals to Odd Page
 
Once I have developed a worksheet and specified a particular column to create
subtotals with a "Page Break Between Groups" my report prints successfully.
However, I usually print my report two-sided Duplex ( "Print on Both Sides")
and I would like a new group (i.e.. after a subtotal appears) to always start
on an odd page number. This will solve the potential problem( depending on
how many pages there are in a group) of the start of one group appearing on
the last page of the prior group.

Is there a solution to this problem?




--
Jim Sheehan
Atlantic Tech Services



All times are GMT +1. The time now is 04:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com