Equivalent to clicking the Move command on the Control menu in Microsoft Excel for Windows or moving a window by dragging its title bar or its icon. Moves the active window so that its upper-left corner is at the specified horizontal and vertical positions. The dialog-box form, WINDOW.MOVE?, is supported only in Microsoft Excel for Windows.
Syntax
WINDOW.MOVE(x_pos, y_pos, window_text)
WINDOW.MOVE?(x_pos, y_pos, window_text)
X_pos is the horizontal position to which you want to move the window. X_pos is measured in points. A point is 1/72nd of an inch.
In Microsoft Excel for Windows, x_pos is measured from the left edge of your workspace to the left edge of the window.
In Microsoft Excel for the Macintosh, x_pos is measured from the left edge of your screen to the left edge of the window.
If x_pos is omitted, the window does not move horizontally.
Y_pos is the vertical position to which you want to move the window. Y_pos in measured in points from the bottom edge of the formula bar to the top edge of the window. If y_pos is omitted, the window does not move vertically.
Window_text specifies which window to restore.
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
If the window is minimized, WINDOW.MOVE moves the icon on the workspace. Measurements are relative to the upper-left corner of the workspace and the icon.
WINDOW.MOVE does not change the size of the window or affect whether the specified window is active or inactive.
In Microsoft Excel for the Macintosh, if window_text is "Clipboard", WINDOW.MOVE moves the Clipboard. The Clipboard must already be available; if it is not available, use the SHOW.CLIPBOARD function before using the WINDOW.MOVE function.
WINDOW.MOVE replaces MOVE in earlier versions of Microsoft Excel.
Related Functions
FORMAT.MOVE Moves the selected object
WINDOW.MAXIMIZE Maximizes a window
WINDOW.MINIMIZE Minimizes a window
WINDOW.RESTORE Restores a window to its previous size
WINDOW.SIZE Changes the size of a window
Return to index