PivotField.AutoSortOrder (Excel)

Returns the order used to sort the specified PivotTable field automatically. Can be one of the XlSortOrder constants.

lngAutoSortOrder = ActiveCell.PivotField.AutoSortOrder xlManual