Specifies what can be selected in a PivotTable during a structured selection. These constants can be combined to select multiple types.

Version Information
Version Added: Excel

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