You would use Appliction.ActivePrinter to designate where the printout goes.

You can manually select a printer. then go to the vbe and the immediate
window and do

? application.ActivePrinter <cr

then go back and change to the other printer and repeat the immediate window
query.

This will give you the strings you need to provide to the activeprinter

then construct a macro that does the printing and assigning.

--
Regards,
Tom Ogilvy


"gkm107" wrote in message
...
i want to print the same Activesheet to two different printers on our
network
but am unable to figure out the code. please help if this is possible