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.

Visual Basic for Applications 
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
auto sort field Auto Sort Field Property AutoSort AutoSortField AutoSortField Property Find out which is the key field for sorting pivottable? Return name of autosort key field?

See also: