Forum Discussion
Macro to change DPI
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 singl...
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.
Thank you! I'll test this out.