Page Break Printing Issue
Last answer on Jan 25, 2009 10:15:58 am GMT Darshan, on Jan 24, 2009 5:58:41 pm GMTHello,
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.
Configuration: Windows XP MS Excel 2003 Firefox 3.0.5
Hi,
|

