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