APP.MOVE

Macro Sheets Only

Equivalent to choosing the Move command from the Control menu for the application window. Moves the Microsoft Excel window. In Microsoft Excel for Windows, if the application window is already maximized APP.MOVE returns the #VALUE! error value and interrupts the macro.

Syntax

APP.MOVE(x_num, y_num)
APP.MOVE?(x_num, y_num)

Note This function is only for Microsoft Excel for Windows. You can use this function in macros created with Microsoft Excel for the Macintosh, but it will return the #N/A error value.

X_num specifies the horizontal position of the Microsoft Excel window measured in points from the left edge of your screen to the left side of the Microsoft Excel window.

Y_num specifies the vertical position of the Microsoft Excel window measured in points from the top edge of your screen to the top of the Microsoft Excel window.

Remarks

• APP.MOVE?, the dialog-box form of the function, doesn't display a dialog box. Instead, it is equivalent to pressing ALT + SPACEBAR, M or to dragging the title bar with the mouse. With APP.MOVE?, you can move the window with the keyboard or mouse.
• If you specify x_num and/or y_num in the dialog-box form of the function, the window is moved according to the specified coordinates, and you are left in move mode.

Related Functions

APP.ACTIVATE Switches to an application

APP.MAXIMIZE Maximizes the Microsoft Excel application window

APP.MINIMIZE Minimizes the Microsoft Excel application window

APP.RESTORE Restores the Microsoft Excel application window

APP.SIZE Changes the size of the Microsoft Excel application window

List of Command-Equivalent Functions