captculver
Board Regular
- Joined
- Dec 8, 2008
- Messages
- 60
I have a pivot table that I wish to filter for 2 values; it appears Excel only will filter for one value. The code I'm using is below; the macro runs without generating any error messages, but the pivot table is filtered only for Value1.
Any suggestions/help appreciated.
Thanks, CC
ActiveSheet.PivotTables("LATE_MEDS_6").PivotFields("THER_CODE_1"). _
PivotFilters.Add Type:=xlCaptionContains, Value1:="20:12", Value2:="08:"
Any suggestions/help appreciated.
Thanks, CC
ActiveSheet.PivotTables("LATE_MEDS_6").PivotFields("THER_CODE_1"). _
PivotFilters.Add Type:=xlCaptionContains, Value1:="20:12", Value2:="08:"