View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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.