I need assistance printing sections of an Excel file to two different network printers. I recorded the macro so it selects the first print area to print to a color printer, then selects the 2nd and 3rd print areas that should print to a black & white printer. Problem is, when I re-run the macro, everything prints to the color printer, it won't change printers for the 2nd & 3rd areas. I've tried everything within my knowledge base of macros to get it to switch printers, but keep messing up the entire macro in the process.
Any assistance on how to make this work is appreciated.
