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 .


expression. AutoSortOrder

expression A variable that represents a PivotField object.


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

PivotField Object