I am trying to set a pivot table filter to All through VBA. When I create a macro to see how it does it I get the below code. Problem is, it doesn't work... No error or anything but the pivot table doesn't filter.....What gives? I am banging my head on the wall here.
Sheets("Chain By Day").PivotTables("PivotTable7").PageFields("Gallons").CurrentPage = _