PivotTable.PivotSelect(String, XlPTSelectionMode, Object) PivotTable.PivotSelect(String, XlPTSelectionMode, Object) Method

Definition

Selects part of a PivotTable report.

public void PivotSelect (string Name, Microsoft.Office.Interop.Excel.XlPTSelectionMode Mode = Microsoft.Office.Interop.Excel.XlPTSelectionMode.xlDataAndLabel, object UseStandardName);
Public Sub PivotSelect (Name As String, Optional Mode As XlPTSelectionMode = Microsoft.Office.Interop.Excel.XlPTSelectionMode.xlDataAndLabel, Optional UseStandardName As Object)

Parameters

Name
String String

Required String. The selection, in standard PivotTable report selection format.

Mode
XlPTSelectionMode XlPTSelectionMode

Optional XlPTSelectionMode. Specifies the structured selection mode.

UseStandardName
Object Object

Optional Object. 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.

Applies to