print 2 sheets on one paper

[inungh]

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

 

[Gord Dibben]

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

 

[CellShocked]

Using even the slightest common sense, I can see that he has enough
sense to know how to do it manually.

Highlighting both sheets, and printing them, setting the printer to
print both sides (if it will) would do it.

Unless what he wants is two sheets on the same side of a single printed
sheet from a single printed job. That would be hard to do.

Perform the sheet handling selection from within the print job settings
interface for the printer, not by and code that MS has for it.

OR convert each print job into a pdf, and then manually paste them into
a single sheet printout. Still more manual operations.

I am sure that he wants an automated, send it and it prints method.

 

[inungh]

  Using even the slightest common sense, I can see that he has enough
sense to know how to do it manually.

  Highlighting both sheets, and printing them, setting the printer to
print both sides (if it will) would do it.

  Unless what he wants is two sheets on the same side of a single printed
sheet from a single printed job.  That would be hard to do.

  Perform the sheet handling selection from within the print job settings
interface for the printer, not by and code that MS has for it.

  OR convert each print job into a pdf, and then manually paste them into
a single sheet printout.  Still more manual operations.

  I am sure that he wants an automated, send it and it prints method.

Thanks for helping,
yes, I have hundreds pages to print. I need a automated method.
Thanks again,

 

[dranon]

Thanks for helping,
yes, I have hundreds pages to print. I need a automated method.
Thanks again,

If controlling the printer specifications manually before printing
won't do it for you, you can combine what Excel can do with what
windows can do with AutoIt.

 

[CellShocked]

If controlling the printer specifications manually before printing
won't do it for you, you can combine what Excel can do with what
windows can do with AutoIt.

Thx for the new additional solution route.