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