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