UsableWidth Property

Applies To

Application Object, Window Object.

Description

Returns the width of the space that can be used by a window in the application window area (the window is not maximized). The width is returned in points (1/72 inch). Read-only.

See Also

UsableHeight Property.

Example

This example expands the active window to the maximum size available (assuming that the window is not already maximized).

With ActiveWindow
    .WindowState = xlNormal
    .Top = 1
    .Left = 1
    .Height = Application.UsableHeight
    .Width = Application.UsableWidth
End With