PivotTable.CompactRowIndent Property
Returns or sets the indent increment for PivotItems when compact row layout form is turned on. Read/write.
Version Information
Version Added: Excel
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.