I'm trying to print two sheets within the same workbook at the same time as a single print job. This way sheet1 is the front and sheet2 the back.
It I do select both sheets and then print active sheets Excel creates two print jobs, forcing the printer to start the second sheet on a new page.
This page break between the prints means that I have two single sheets printed out of the printer rather than one piece of paper in duplex.
Any ideas on a work around for this?
The two two sheets are only a sinlge page in size, but have different column widths so wont easily go onto a single worksheet.
Bookmarks