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

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

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,123,239
Messages
5,600,486
Members
414,383
Latest member
konmtu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top