
This Excel VBA tutorial explains how to set print area, page width, Print Title, Orientation in Excel VBA.
Excel VBA set print area
To set Print Area in Excel spreadsheet, first select (highlight) Cells that we want to set as Print Area, and then navigate to ribbon Page Layout > Print Area > Set Print Area
To set Print Area in Excel VBA, we have to use PageSetup.PrintArea Property.
For example, in order to set Print Area A1:N21, we can write
Public Sub printArea()
Active...
Read More