I'm trying to add a filter for my pivot table that will only display 'string I want to filter by' in the pivot table, and this is what I currently have based off a similar question:
But when I try to run this part of the macro, I get runtime error 1004: unable to set the CurrentPage property of the PivotField class. Any idea on how to fix this? Also I would prefer if I could have a static filter 'string I want to filter by' instead of a reference to it but I'll take what I can get.
![Pack Pack](http://droidz.org/resources/12120867587.jpg)
Community♦
Jul 28, 2012 A guide to what melee weapons you should and should not use in the case of a Zombie Apocalypse. A collection of Pivot animations in the form of a.
DavidDavid