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

948 Steps to 6 Figures by Learning Excel-VBA and Other Skills

Step 726 - 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.