set up a pause in a print macro for user input
 

In creating a macro to print a section of the worksheet, I need to allow the
user to select the printer location and number of copies desired.

set up a pause in a print macro for user input
 

application.Dialogs(xlDialogPrint).show

--
Regards,
Tom Ogilvy

"Scott53" wrote in message
...
In creating a macro to print a section of the worksheet, I need to allow
the
user to select the printer location and number of copies desired.