Window.Height (Excel)

Returns or sets a Double value that represents the height, in points, of the window.

Use the UsableHeight property to determine the maximum size for the window. You cannot set this property if the window is maximized or minimized. Use the WindowState property to determine the window state.

ActiveWindow.Height =