Excel 2010 VBA Pivot update

[PJBM]

When automating Pivot tables, updated via VBA if you record a macro of down click in the filter (page) area and click ok it produces the Pseudo code like:-



Pivottable.PivotFields("[Variable").ClearAllFilters
Pivottable.PivotFields["Variable"]).CurrentPageName = "[Variable]&.&[Filteritem]"

If I remove Pivottable.PivotFields("[Variable").ClearAllFilters code line
the result ie that the pivottable is updated ... seems the same

Whats the difference?

 

[taigovinda]

Any time you use the recorder, it tends to insert a bunch of extra code. Like, if you right-click a cell and delete it, you will probably get at least two recorded steps (select and delete). I expect that, absent the second line, the first line of your code would do just what it says, remove all (page) filters.