Height Property

Returns or sets the height of the specified object in points.

• Read-only Double for the Window object.

• Read-only Variant for the Range object.

• Read-write Long for the PivotAxisMember, PivotColumnMember, PivotPageMember, PivotRowMember, and PivotTable objects.

• Read-only Long for all other objects in the Applies To list.

expression.Height

*expression   * Required. An expression that returns one of the objects in the Applies To list.

Remarks

The AutoFit property of the PivotTable list is set to False when the value of the Height property is changed.

Example

This example sets the height of the PivotTable list to 36 points.

PivotTable1.Object.Height = 36

Applies to | PivotAxisMember Object | PivotColumnMember Object | PivotDetailCell Object | PivotPageMember Object | PivotResultAxis Object | PivotResultColumnAxis Object | PivotResultDataAxis Object | PivotResultFilterAxis Object | PivotResultGroupAxis Object | PivotResultLabel Object | PivotResultPageAxis Object | PivotResultRowAxis Object | PivotRowMember Object | PivotTable Object | Range Object | Window Object

See Also | Width Property