Page Break Printing Issue

Closed
Darshan - Jan 24, 2009 at 12:58 PM
Elizabeth14 Posts 8 Registration date Sunday January 4, 2009 Status Member Last seen June 9, 2009 - Jan 25, 2009 at 05:15 AM
Hello,
I have a worksheet with sub-totals and page breaks auto inserted at the end of each sub-total. I want to print this report double sided, but with a condition. If an area between two page breaks fits onto a single of the paper, then I do not want to print the next break on the same sheet of paper.

If however, the area between two page breaks exceed one side of a paper and gets printed on the other, then I don't have an issue.

In short, I am trying to eject the paper from the printer if the data within a given break is printable on one side, and avoid the next chunk of data to get printed on the other side of the same sheet. Is this possible? Are there any addins/macros/VB codes that could deal with such printing requirements?? Please help.
Related:

1 response

Elizabeth14 Posts 8 Registration date Sunday January 4, 2009 Status Member Last seen June 9, 2009
Jan 25, 2009 at 05:15 AM
hi,
try this link to see if it can help you:
https://www.ozgrid.com/VBA/
0