Thread: Change Printer
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
 
Posts: 2,337
Default 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