Macro to print worksheet

[PEAKCAB]

Hi, I need some help with getting a Macro to print a worksheet. I have used the podcast #1505 for invoice with next number. I already have it printing to PDF but would like would also like a paper copy at the same time but are really unsure how to go about it and where exactly where to put it in the macro.

Any help would be greatly received

Rich

 

[davesexcel]

You should be able to print the worksheet and saveas pdf in the same macro