Height Property

Applies To

Application object, Axis object, ChartArea object, ChartObject object, ChartObjects collection object, Legend object, LegendEntry object, LegendKey object, OLEObject object, OLEObjects collection object, PlotArea object, Range object, Shape object, ShapeRange collection object, Window object.

Description

Returns or sets the height of an object, in points. Read/write Long, except as shown in the following table.

Remarks

The meaning of the Height property depends on the specified object.

Object type

Height

Application

The height of the main application window. On the Macintosh, this is always equal to the total height of the screen, in points. Setting this value to something else on the Macintosh will have no effect. In Windows, 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.


(continued)

Axis, LegendEntry, LegendKey

The height of the object. Read-only.

Range

The height of the range. Read-only.

Window

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.

ChartArea, ChartObject, Legend, OLEObject, PlotArea, Shape, ShapeRange

The height of the object.


See Also

Left property, Top property, Width property.

Example

This example sets the height of the embedded chart.

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