PageSetup.PrintArea property (Excel)
Returns or sets the range to be printed as a String using A1-style references in the language of the macro. Read/write String.
expression A variable that represents a PageSetup object.
Set this property to False or to the empty string ("") to set the print area to the entire sheet.
This property applies only to worksheet pages.
This example sets the print area to cells A1:C5 on Sheet1.
Worksheets("Sheet1").PageSetup.PrintArea = "$A$1:$C$5"
This example sets the print area to the current region on Sheet1. Note that you use the Address property to return an A1-style address.
Worksheets("Sheet1").Activate ActiveSheet.PageSetup.PrintArea = _ ActiveCell.CurrentRegion.Address
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.