PageSetup.Zoom Property

Excel Developer Reference

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.

Visual Basic for Applications
  Worksheets("Sheet1").PageSetup.Zoom = 150

See Also