WINDOW.SIZE

Macro Sheets Only

Equivalent to choosing the Size command from the Control menu or to adjusting the sizing borders (in Microsoft Excel for Windows) or the sizing box (in Microsoft Excel for the Macintosh) of the window with the mouse. Changes the size of the active window by moving its lower-right corner so that the window has the width and height you specify. WINDOW.SIZE does not change the position of the upper-left corner of the window, nor does it affect whether the specified window is active or inactive.

Syntax

WINDOW.SIZE(width, height, window_text)
WINDOW.SIZE?(width, height, window_text)

Width specifies the width of the window and is measured in points. A point is 1/72nd of an inch.

Height specifies the height of the window and is measured in points.

Window_text specifies which window to size.

• Window_text is text enclosed in quotation marks or a reference to a cell containing text.
• If window_text is omitted, it is assumed to be the name of the active window.

Remarks

• In Microsoft Excel for Windows, an error occurs if you try to resize a window that has already been minimized to an icon or enlarged to its maximum size. You must first restore the window to its original size using the WINDOW.RESTORE formula. For more information, see WINDOW.RESTORE.
• WINDOW.SIZE replaces SIZE in earlier versions of Microsoft Excel.

Related Functions

FORMAT.SIZE Sizes an object

WINDOW.MAXIMIZE Maximizes a window

WINDOW.MINIMIZE Minimizes a window

WINDOW.MOVE Moves a window

WINDOW.RESTORE Restores a window to its previous size

List of Command-Equivalent Functions