Look at the Application.ActivePrinter method in Excel VBA Help.

--
Regards,
Tom Ogilvy

"HCS" wrote in message
...
Hello,
when using the printout command the page simply prints out to the default
printer. how can you use vb to select a printer

cheers