Height Property

Microsoft Excel Visual Basic

The height of the main application window. If the window is minimized, this property is read-only and refers to the height of the icon. If the window is maximized, this property cannot be set. Use the WindowState property to determine the window state. Read/write Double.

expression.Height

expression    Required. An expression that returns an Application object.

ShowHeight property as it applies to the Window object.

The height of the window. Use the UsableHeight property to determine the maximum size for the window. You cannot set this property if the window is maximized or minimized. Use the WindowState property to determine the window state. Read/write Double.

expression.Height

expression    Required. An expression that returns a Window object.

ShowHeight property as it applies to the ChartArea, ChartObject, ChartObjects, Legend, OLEObject, OLEObjects, and PlotArea objects.

The height of the object. Read/write Double.

expression.Height

expression    Required. An expression that returns one of the above objects.

ShowHeight property as it applies to the Axis, LegendEntry, and LegendKey objects.

The height of the object. Read-only Double.

expression.Height

expression    Required. An expression that returns one of the above objects.

ShowHeight property as it applies to the Graphic, Shape, and ShapeRange objects.

The height of the object. Read/write Single.

expression.Height

expression    Required. An expression that returns one of the above objects.

ShowHeight property as it applies to the Range object.

The height of the range. Read-only Variant.

expression.Height

expression    Required. An expression that returns a Range object.

Example

This example sets the height of the embedded chart.

Worksheets("Sheet1").ChartObjects(1).Height = 288