This documentation is archived and is not being maintained.

Application.UsableHeight Property

Office 2007
Returns the maximum height of the space that a window can occupy in the application window area, in points. Read-only Double.

Syntax

expression.UsableHeight

expression   A variable that represents an Application object.

Example

This example expands the active window to the maximum size available (assuming that the window isn't already maximized).

Visual Basic for Applications
With ActiveWindow
    .WindowState = xlNormal
    .Top = 1
    .Left = 1
    .Height = Application.UsableHeight
    .Width = Application.UsableWidth
End With



Show: