Duplex printing

[Guest]

I have one worksheet of about 7700 rows. This would yield about 375 pages
single-sided, want to duplex to about 189 or so pages. Using HP LJ 1022,
which does not support duplex...I think. Any suggestions?
Thx

 

[Ian]

One solution.

Use a PDF print utility to create a PDF of the worksheet, then use Adobe
Reader to print it out selecting first the odd pages, then the even.

 

[Guest]

Thx, I'll give it a try.

One solution.

Use a PDF print utility to create a PDF of the worksheet, then use Adobe
Reader to print it out selecting first the odd pages, then the even.

 

[Gord Dibben]

See Ron deBruin's site for VBA code to print odd and even pages.

http://www.rondebruin.nl/print.htm#odd


Gord Dibben MS Excel MVP