MaxHeight Property

  • Article

MaxHeight property as it applies to the PivotTable object.

Returns or sets the maximum height in pixels that the specified PivotTable list can attain when the value of the AutoFit property is True. A vertical scroll bar is displayed if there is more data available that cannot be displayed within the maximum height. The default value is 32,000 pixels. Read/write Long.

expression.MaxHeight

*expression   * Required. An expression that returns a PivotTable object.

MaxHeight property as it applies to the Spreadsheet object.

Returns or sets the maximum height that the specified spreadsheet can attain when the value of the AutoFit property is True. A vertical scroll bar is displayed if there is more data available that cannot be displayed within the maximum height. The value is in pixels or a percentage of the container window height (expressed as a string such as "50%"). The default value is 80%. Read/write Variant.

expression.MaxHeight

*expression   * Required. An expression that returns a Spreadsheet object.

Applies to | PivotTable Object | Spreadsheet Object

See Also | MaxWidth Property