XlPivotLineType enumeration (Excel)
Specifies the type of the PivotLine.
| Name | Value | Description |
|---|---|---|
| xlPivotLineBlank | 3 | Blank line after each group. |
| xlPivotLineGrandTotal | 2 | Grand Total line. |
| xlPivotLineRegular | 0 | Regular PivotLine with pivot items. |
| xlPivotLineSubtotal | 1 | Subtotal line. |
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.