HairyHippy
Programmer
Hi
I currently have the following code:
But I need to select 2 values but the following won't work:
I'd rather use something similar to the above as it seems to run quicker than using the following code:
Any suggestions on how to achieve this?
I currently have the following code:
Code:
Sheets("New New Deals").PivotTables("PivotTable2").PivotFields("EMEA Mkts").PivotFilters.Add _
Type:=xlCaptionEquals, Value1:="BENELUX"
But I need to select 2 values but the following won't work:
Code:
Sheets("New New Deals").PivotTables("PivotTable2").PivotFields("EMEA Mkts").PivotFilters.Add _
Type:=xlCaptionEquals, Value1:="BENELUX", Value2:="Nordics"
I'd rather use something similar to the above as it seems to run quicker than using the following code:
Code:
With ActiveSheet.PivotTables("PivotTable2").PivotFields("EMEA Mkts")
.PivotItems("BeneLux").Visible = False
.PivotItems("Other SSA").Visible = False
.PivotItems("South Africa").Visible = False
.PivotItems("MENA").Visible = False
.PivotItems("Mediterranean").Visible = False
End With
Any suggestions on how to achieve this?