I am using the following code to printout a worksheet and am having
some problems.

1. I cannot get it to print in color. Is there a way to specify this
inside of the .Printout method.

2. I cannot get it to duplex. Is there a way to specify this? I have
my printing preferences set to both of these settings.

ActiveSheet.Range("A1:G53").PrintOut , Copies:=2, preview:=False,
ActivePrinter:="\\HaddonSrvr\Ricoh 2232C", printtofile:=False,
Collate:=True, prtofilename:=PSFileName


Thanks in advance.