PivotTable.CompactRowIndent (Excel)

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

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

ActiveCell.PivotTable.CompactRowIndent =