Hello,
I currently have the following code in my worksheet:
The problem is I only want to clear the "Report Filter" field, not all filters. Is there a way to do this?![]()
For Each pt In ActiveSheet.PivotTables With pt.PivotFields("NMLS LO ID") .ClearAllFilters .CurrentPage = txtNMLSID.Value End With Next pt
Thanks in advance.
Bookmarks