Show All

PivotSelectionStandard Property

Returns or sets a String indicating the PivotTable selection in standard PivotTable report format using English (United States) settings. Read/write.

expression   Required. An expression that returns 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