Macro to change DPI

[Logan_Weaver]

Good day!

First off, I am not an Excel expert at all, so I apologize for a question that may or may not be really dumb :)

I am in need of a macro in Excel that would change the DPI of a single worksheet. The reason for this is because occasionally I have a worksheet that needs to be set to 204x196 DPI in order to print/fax properly. I would basically like to achieve what is in this guide: Change the print resolution or print quality for a worksheet - Excel (microsoft.com) but through a macro.

If it needs to be done manually that is fine, but hopefully someone can provide some guidance? :) Thank you!!

[#2]

@Logan_Weaver 

You can use this for the active sheet:

ActiveSheet.PageSetup.PrintQuality = Array(240, 196)

or for a specific sheet that is not necessarily the active sheet:

Worksheets("Specific Sheet").PageSetup.PrintQuality = Array(240, 196)

But the active printer must support that, otherwise you'll get an error message.

[#3]

Thank you! I'll test this out.