hi Josh,

Rather than using an autofilter would it work if you recorded a macro
of rightclicking on a cell in the "row fields" section of the pivot
table, choosing Field Settings - Advanced - Sort... which should
generate something like the below code?

Code:
--------------------
ActiveSheet.PivotTables("PivotTable1").PivotFields ("gf").AutoSort xlDescending, "Sum of dgf"
--------------------


hth
Rob


--
broro183

Rob Brockett. Always learning & the best way to learn is to
experience...
------------------------------------------------------------------------
broro183's Profile: http://www.thecodecage.com/forumz/member.php?userid=333
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=118446