PivotTable.PivotSelect(String, XlPTSelectionMode, Object) Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
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
Required String. The selection, in standard PivotTable report selection format.
- Mode
- XlPTSelectionMode
Optional XlPTSelectionMode. Specifies the structured selection mode.
- UseStandardName
- 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.