PivotTable.PivotSelect Method

  • Article
Excel Developer Reference

Selects part of a PivotTable report.

Syntax

expression.PivotSelect(Name, Mode, UseStandardName)

expression   A variable that represents a PivotTable object.

Parameters

Name Required/Optional Data Type Description
Name Required String The part of the PivotTable report to select.
Mode Optional XlPTSelectionMode Specifies the structured selection mode.
UseStandardName Optional Variant True for recorded macros that will play back in other locales.

Remarks

You can use the specified mode only to select the corresponding item in the PivotTable report. For example, you cannot select data and labels by using xlButton mode; likewise, you cannot select buttons by using xlDataOnly mode.

Example

This example selects all date labels in the first PivotTable report on worksheet one.

Visual Basic for Applications 
  Worksheets(1).PivotTables(1).PivotSelect "date[All]", xlLabelOnly

See Also