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

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

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.


On Tue, 04 Jan 2011 13:32:58 -0800, Gord Dibben wrote:

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

On Jan 4, 8:15*pm, CellShocked
<cellshoc...@thecellvalueattheendofthespreadsheet. org wrote:
* 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.







On Tue, 04 Jan 2011 13:32:58 -0800, Gord Dibben wrote:
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

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

On Tue, 4 Jan 2011 19:32:30 -0800 (PST), inungh
wrote:

On Jan 4, 8:15*pm, CellShocked
<cellshoc...@thecellvalueattheendofthespreadsheet .org wrote:
* 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.







On Tue, 04 Jan 2011 13:32:58 -0800, Gord Dibben wrote:
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

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.

On Wed, 05 Jan 2011 00:24:33 -0800, dranon
wrote:


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.