Hello
I want to set multiple label filters on my pivot table, so that it will show Column B dates with a "6" or a " ' " in them.
I have the following code, but it does one after the other and ignores the first. How do/can I combine them?
Sub FormatPivot()
ActiveSheet.PivotTables("Monthly ").PivotFields("Date"). _
ClearAllFilters
ActiveSheet.PivotTables("Monthly ").PivotFields("Date").PivotFilters.Add Type:=xlCaptionBeginsWith Value1:="6"
ActiveSheet.PivotTables("Monthly ").PivotFields("Date").PivotFilters.Add Type:=xlCaptionEquals Value1:="'"
End Sub
Bookmarks