PivotField.AutoSort Method

Establishes automatic field-sorting rules for PivotTable reports.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Sub AutoSort ( _
    Order As Integer, _
    Field As String _
)
'Usage
Dim instance As PivotField
Dim Order As Integer
Dim Field As String

instance.AutoSort(Order, Field)

void AutoSort(
    int Order,
    string Field
)

Parameters

• Order
  Type: System.Int32

  Required XlSortOrder. The sort order.

• Field
  Type: System.String

  Required String. The name of the sort key field. You must specify the unique name (as returned from the SourceName property) and not the displayed name.

See Also

Reference

PivotField Interface

PivotField Members

Microsoft.Office.Interop.Excel Namespace