You are trying to print 2 worksheets back to back on one sheet of paper?

Your code will not do that...................it calls for two printjobs.

Will the printrange on each worksheet fit on one sheet of paper?

Print one worksheet then reverse paper and print other worksheet.


Gord Dibben MS Excel MVP




On Tue, 4 Jan 2011 12:33:28 -0800 (PST), inungh wrote:

I use following code to print my spreadsheet and would like to pirnt
it on the same paper on 2 side.

It seems that Excel sends out to print 2 times and it always print on
2 papers, but not one papaer on 2 sides.

Are there any way, to print 2 sheets in one shot to send to printer?
I tried to merge 2 sheets, but Front and backing are not same columns
setting to make it difficult to print.

Your help is great appreciated,

Sheets("FRONT")..PrintOut Copies:=1, Collate:=True
Sheets("BACKING").PrintOut Copies:=1, Collate:=True