View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Can you print multiple worksheets double sided?

Using VBA code you can set the same print range and rows to repeat at top on
each sheet in grouped sheets.

For anyone interested in the code see this google search result with Dave
Peterson and myself posting. The print area code is from Bob Flanagan.

http://snipurl.com/106kz


Gord Dibben MS Excel MVP



On Mon, 21 Apr 2008 15:02:12 -0700, rviviana
wrote:

I am trying to pick the print area to be the same on all sheets and I am
trying to avoid going into each sheet because I have 50 sheets. There has to
be a way to save time.
Rosemary