Export (0) Print
Expand All
Expand Minimize

Application.UsableWidth Property

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

Syntax

expression.UsableWidth

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



Community Additions

ADD
Show:
© 2015 Microsoft