Notitie
Voor toegang tot deze pagina is autorisatie vereist. U kunt proberen u aan te melden of de directory te wijzigen.
Voor toegang tot deze pagina is autorisatie vereist. U kunt proberen de mappen te wijzigen.
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.