Does this need a macro to perform the task?

http://www.excelforum.com/showthread.php?t=56281

--
dzi
-----------------------------------------------------------------------
dziw's Profile: http://www.excelforum.com/member.php...fo&userid=1042
View this thread: http://www.excelforum.com/showthread.php?threadid=56285

dziw wrote:
Does this need a macro to perform the task?

http://www.excelforum.com/showthread.php?t=562818


--
dziw
------------------------------------------------------------------------
dziw's Profile: http://www.excelforum.com/member.php...o&userid=10422
View this thread: http://www.excelforum.com/showthread...hreadid=562851

Have your code set page breaks apprpriately then set your printer
properties to double sided.

Hope this helps

AR

I have page breaks set and each individual page from sheet1 prints o
individual printed paper sheet ok. The problem I have is getting it t
print sheet2 on the reverse of every printed paper sheet. I'm not
programmer and to be honest wouldn't know where to start.

Someone has suggested that I print all the sheet1 pages, flip the pape
and print sheet2 but with the number of times I have to do this it woul
prove to be time consuming. Plus sheet2 changes occasionally so I don'
want to print a batch. As stated the printer is duplex so is capable o
flipping the paper.

Does anyone have any code that could perform this? Any help would b
very much appreciated :

--
dzi
-----------------------------------------------------------------------
dziw's Profile: http://www.excelforum.com/member.php...fo&userid=1042
View this thread: http://www.excelforum.com/showthread.php?threadid=56285