Height Property

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

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