By using listi.net you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

listi.net

ActiveSheet.PivotTables("pt1").PivotFields("Acct_nbr").Autosort xldescending, sort ' recorded

This code was recorded while processing a Pivot Table.

It's sorting the Pivot table descending Z to A on a field called Acct_nbr.

You must first know how to sort on a field manually before recording the macro.