How can I return what values field a particular pivot field is sorted by? For instance, my customer pivot table could be sorted descending by either this year sales, next year sales ... and in VBA I want to return into a variable which values field it is current sorted by. How can I get at this information?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Return the filter applied to pivot table in VBA
- Thread starter cr731
- Start date
