Printer Trays in VBA

I have recorded a macro to print my sheets. I need to print some sheets single-sided and others double-sided. Is it possible to create a macro to do this?

By Neale Blackwood
Macros don’t have many limitations, but changing printer settings is one of them. The solution is to set up two printers on your system. One has single-sided as the default and the other has double-sided (duplex).

When you record the macro, simply select your sheet and change printers and print, and then select another sheet and another printer and print. The macro recorder will record changes in the printers selected.