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/


--
mrice
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=532721