Macro to print on both sides
 

If you want them on a single side of the same sheet of paper:

select the area you want printed and do
File=Page Setup and on the first tab, select Fit to+ 1 page(s) wide by 1
page(s) tall

Regards,
Tom Ogilvy


"Herb" wrote in message
...
I have two sheets in one workbook I need to print on one
sheet. Can this be done with a macro?

Thanks for your help.