Print To Two Different Network Printers

gbaker101

New Member
Joined
Sep 24, 2003
Messages
24
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. :mad: Any assistance on how to make this work is appreciated.
 

Some videos you may like

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,524
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
where on the network do they live, do they have specific names / paths, what is your current code (place between code tags here)
 

Watch MrExcel Video

Forum statistics

Threads
1,118,661
Messages
5,573,475
Members
412,531
Latest member
gkrishna788
Top