PivotTable.SelectionMode (Excel)

Returns or sets the PivotTable report structured selection mode.

xlBlanks - Blanks, xlButton - Buttons, xlDataAndLabel - Data and labels, xlDataOnly - Data, xlFirstRow - First row, xlLabelOnly - Label, xlOrigin - Origin.

If the PivotTable field isn't in outline form, specifying the sum of any of the constants and xlFirstRow is equivalent to specifying the constant alone.

ActiveCell.PivotTable.SelectionMode = xlBlanks
PivotTable.SelectionMode procedure builder