Pivot table select multiple selection page filters

SteveWright

New Member
Joined
Aug 26, 2009
Messages
44
Hi, I'm sure this question must have been asked before but cant for the life of me find it on here (or anywhere!).

I need to programatically edit pivot table filter values using vba. If I'm changing one value i have no problem but I cant work out how to use multiple values on the page filter. Any ideas guys?
 

Fazza

MrExcel MVP
Joined
May 17, 2006
Messages
9,201
Maybe like on the worksheet? That is, make it a different field - such as a row field - make the changes and then return it to the page field.
 

Forum statistics

Threads
1,085,329
Messages
5,382,993
Members
401,812
Latest member
emelyan1379

Some videos you may like

This Week's Hot Topics

Top