UsableHeight Property [Excel 2007 Developer Reference]

Switch View :
Classic
Lightweight
ScriptFree
Application.UsableHeight Property
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

See Also