Hello Brent,

As far as I know, the double sided option has to set using the printe
dialog. There are no VBA commands to do that. You can call the printe
dialog from code, if that would help.

TO DISPLAY THE PRINTER DIALOG
Excel.Application.Dialogs(xlDialogPrint).Show

Sincerely,
Leith Ros

--
Leith Ros
-----------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846
View this thread: http://www.excelforum.com/showthread.php?threadid=47895