Try this line of code...

Application.Dialogs(xlDialogPrinterSetup).Show
--
HTH...

Jim Thomlinson


"leerem" wrote:

Hi everyone:

I need to be able to print a selection (worksheet) to a network printer.
However I am not goiing to be able to identify the printer within the code.
Is there away of printing the selected area wherby the user then selects the
required network printer in their office.

Regards
Lee