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



expression A variable that represents a PivotTable object.

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

See Also