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.

Syntax

expression.Zoom

expression A variable that represents a PageSetup object.

Remarks

This property applies only to worksheets.

If this property is False, the FitToPagesWide and FitToPagesTall properties control how the worksheet is scaled.

All scaling retains the aspect ratio of the original document.

Example

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.