VBA code to use default printer on local pc for printing

Hi,

I'm trying to get some coding changed to be able to use whatever default printer a user have on their windows pc to print specific sheet. Currently the code I have to work with is:

Please Login or Register  to view this content.

But I need to have the Application.ActivePrinter changed so it uses the default printer from windows O/S.

Hope someone can give me a helping hand to get this working.

Thanks.

Hi DanishDude,

Here is some code that worked for me. It basically sets the print area to the range "PaysheetPrint", then sets the page layout so that the selected print area is scaled to fit on one sheet of 8 1/2 x 11 paper and then it selects the "PaysheetPrint" range and prints it. Setting the print area and the page layout to "PaysheetPrint" may be redundant, but it is late here, so I thought I would post this before I fall asleep in my chair. The code is given below:

Please Login or Register  to view this content.

Hope this helps,

Daniel