ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   changing pivot selection (https://www.excelbanter.com/excel-programming/326910-changing-pivot-selection.html)

Ward

changing pivot selection
 
I have the following line in my macro:
FREEDOM.PivotTables("FREEDOM").PivotFields("POS"). CurrentPage = sPOS

Now I want to change two pivot fields at once. If I put two of these lines
after eachother, excel will change the first field, update the pivot (which
is large) and then change the second and again an update.

Can I first change both fields, and then update the table.

Thanx.


All times are GMT +1. The time now is 03:22 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com