Skip to content

Latest commit

 

History

History
42 lines (28 loc) · 948 Bytes

Excel.Application.UsableHeight.md

File metadata and controls

42 lines (28 loc) · 948 Bytes
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Application.UsableHeight property (Excel)
vbaxl10.chm133222
vbaxl10.chm133222
Excel.Application.UsableHeight
536d2d03-0ce8-c28a-5a94-461fcfbd4ebf
04/05/2019
medium

Application.UsableHeight property (Excel)

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).

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

[!includeSupport and feedback]