MaxHeight Property

See Also                  Applies To

Returns or sets the maximum height that the specified PivotTable list or 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. For PivotTable lists, the value is in pixels. For spreadsheets, the value is in pixels or a percentage of the container window height (expressed as a string such as "50%"). The default value is 32,000 pixels for PivotTable lists, and 80% for spreadsheets. Read/write Long for PivotTable; read/write Variant for Spreadsheet.