Share via


PivotField.AutoSortOrder Property (Excel)

Returns the order used to sort the specified PivotTable field automatically. Can be one of the constants of XlSortOrder. Read-only Long.

Syntax

expression .AutoSortOrder

expression A variable that represents a PivotField object.

Example

This example displays a message box showing the AutoSort parameters for the Product field.

With Worksheets(1).PivotTables(1).PivotFields("product") 
 Select Case .AutoSortOrder 
 Case xlManual 
 aso = "manual" 
 Case xlAscending 
 aso = "ascending" 
 Case xlDescending 
 aso = "descending" 
 End Select 
 MsgBox " sorted in " & aso & _ 
 " order by " & .AutoSortField 
End With

See Also

Concepts

PivotField Object

PivotField Object Members