PivotTable.CompactRowIndent Property

Excel Developer Reference

Returns or sets the indent increment for PivotItems when compact row layout form is turned on. Read/write.

Version Information
Version Added: Excel 2007

Syntax

expression.CompactRowIndent

expression A variable that represents a PivotTable object.

Remarks
The default value is 1. The valid values for this setting are 0 to the maximum indent specified in Microsoft Excel.

See Also