Re: Printing two tabs of the same worksheet to one double-sided page

I have a worksheet that is filled out by our various division. The workbook
has two tabs.

Right now, I have set it up so that each tab prints to fit one page. I go
to the first tab, print on one page, then go the the second tab, and print it
on one page.

Ideally, I would like to print these double-sided on the same piece of paper.

I would also like to figure out a way to automate this task (perhaps using
macros?). These are monthly reports which come in from over 30 divisions. It
takes a long time to do this manually, even with the macros I currently have.
[ I curently have a macro set-up which sets the page formatting to fit to
one page. I go to each tab and use the shortcut to this macro.]

I would appreciate help regarding how to print on the same piece, and if
possible, how to do this automatically.

Sicnerely,

Jennifer

Jennifer

Double sided printing is most likely to a setting on your printer.

You can go through all your sheets by wrapping your macro within a for -next loop.


For Each Sheet in ActiveWorkbook
...
Your code
....
Next Sheet

Martin

http://homepage.ntlworld.com/martin.rice1/