Set to default printer

[brianfosterblack]

Excel 2007

I am using this line of code to print to pdf
Application.ActivePrinter = "Nitro PDF Creator 2 on Ne08:"
How do set the worksheet back to the default printer.

I am distributing the workbook so I need it to reset to the default printer for the computer being used - not mine.

 

[brianfosterblack]

Leith,

This works absolutely perfectly.

Thank you so much for solving a big problem for me

 

[brianfosterblack]

This works perfectly, thank you so much

 

[Leith Ross]

Hello brianfosterblack,

You're welcome.