Change Printer

[Brady Snow]

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

 

[Don Guillett]

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