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 property 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 that 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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.