XlPTSelectionMode enumeration (Excel)
Specifies what can be selected in a PivotTable during a structured selection. These constants can be combined to select multiple types.
| Name | Value | Description |
|---|---|---|
| xlBlanks | 4 | Blanks |
| xlButton | 15 | Buttons |
| xlDataAndLabel | 0 | Data and labels |
| xlDataOnly | 2 | Data |
| xlFirstRow | 256 | First row |
| xlLabelOnly | 1 | Label |
| xlOrigin | 3 | Origin |
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.