PivotTable.CompactRowIndent property (Excel)

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

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.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.