PivotTable.PivotSelectionStandard Property (Excel)
Returns or sets a String indicating the PivotTable selection in standard PivotTable report format using English (United States) settings. Read/write.
Syntax
expression .PivotSelectionStandard
expression A variable that represents a PivotTable object.
Remarks
The PivotSelectionStandard property is "international-friendly" whereas the PivotSelection method is not.
Example
This example selects a field titled "1.57" in the PivotTable and inserts a blank column field before it. The example assumes a PivotTable exists on the active worksheet that contains a column field titled "1.57".
Sub CheckPivotSelectionStandard()
Dim pvtTable As PivotTable
Set pvtTable = ActiveSheet.PivotTables(1)
pvtTable.PivotSelectionStandard = "1.57"
Selection.Insert
End Sub