Change Printer
 

I am trying to print a workbook where each of the three
worksheets and or print ranges are printed to a different
printer. For example...

I set the print range of the first sheet to be printed.
So print range 1 goes to HP Printer 1.

The second print range goes to HP Printer 2.

These printer are setup on my pc.

Many Thanks,

Brady Snow
McKinney, Texas

Change Printer
 

Have you tried recording a macro while you do this manually.

"Brady Snow" wrote in message
...
I am trying to print a workbook where each of the three
worksheets and or print ranges are printed to a different
printer. For example...

I set the print range of the first sheet to be printed.
So print range 1 goes to HP Printer 1.

The second print range goes to HP Printer 2.

These printer are setup on my pc.

Many Thanks,

Brady Snow
McKinney, Texas