PivotTable.SelectionMode (Excel)

Returns or sets the PivotTable report structured selection mode. Possible return values are 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