PivotFields("Field1").ClearAllFilters - whart does this do?
Private Sub SubProc1()
Sheets("Pivot-view").Select
ActiveSheet.PivotTables("PivotTable1").PivotFields("Field1").ClearAllFilters
End Sub
Can you please advise what this does? I have many different values in
Field1 (display field of a pivot table). For a test I have selected only
two, then I ran the subprocedure. Nothing happened... I would have
expected the filter to be cleared so that all values from Field1 are
visible. No syntax error either. Thank you.
No comments:
Post a Comment