PivotField.AutoSortField Property (Excel)
Returns the name of the data field used to sort the specified PivotTable field automatically. Read-only String.
Syntax
expression .AutoSortField
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