PageSetup.Zoom property (Excel)
Returns or sets a Variant value that represents a percentage (between 10 and 400 percent) by which Microsoft Excel will scale the worksheet for printing.
expression A variable that represents a PageSetup object.
This property applies only to worksheets.
All scaling retains the aspect ratio of the original document.
This example scales Sheet1 by 150 percent when the worksheet is printed.
Worksheets("Sheet1").PageSetup.Zoom = 150
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.