I have several instances of identically structured workbooks that choose which pages (ranges) to print based on set criteria. A macro runs through the list of pages and adds all which meet the criteria to a variable named rngPrint using union. When all pages have been checked and either added or skipped, I simply use rngPrint.printout. This method has been working great until we got a new printer with a double-sided print option. Now, everything prints double-sided even though the setting is turned off in the printer menu AND the printer properties within Excel. These documents cannot be double-sided as many pages go to different places.
Is there any way to force excel to print single-sided with the printout method?
My current workaround is to send every page as a separate job, but that is not a good long term solution since it takes so much longer and we print hundreds of pages a day.
Thanks in advance!