Skip to main content

Window.Zoom property

Table of contents
  1. Syntax
  2. Remarks
  3. Examples

Returns or sets a Variant value that represents the display size of the window, as a percentage (100 equals normal size, 200 equals double size, and so on).

Syntax

expression.Zoom

expression A variable that represents a Window object.

Remarks

You can also set this property to True to make the window size fit the current selection.

This function affects only the sheet that's currently active in the window. To use this property on other sheets, you must first activate them.

Examples

The following example zooms the active Excel window to 200%.

ActiveWindow.Zoom = 200

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>