Hi Guys....m new to this forum and m not sure this is already posted by other members or not.

i would really appreciate if any one help with this, i need to know whether it is possible have a VBA/Macros script where we can specify to select the group while filtering the data in pivot table and if the group is not found then it should skip and continue selecting other groups.

Right now when i look at the Macros script, i see that it deselecting all the other groups


ActiveSheet.PivotTables("PivotTable09").PivotFields("Assigned Group*+"). _
CurrentPage = "(All)"
With ActiveSheet.PivotTables("PivotTable09").PivotFields("Assigned Group*+")
.PivotItems("APAC Desktop Tower").Visible = False
.PivotItems("Asset Management").Visible = False
.PivotItems("Carrier support").Visible = False
.PivotItems("CET-Customer").Visible = False
.PivotItems("CET-Logistics").Visible = False
.PivotItems("Customer L2").Visible = False
.PivotItems("Finance L2").Visible = False
.PivotItems("Information Access L2").Visible = False
.PivotItems("L2 ECS*AAS SAP").Visible = False
.PivotItems("L2 *ECS Oracle DBA").Visible = False
.PivotItems("L2 *ECS SQL DBA").Visible = False
.PivotItems("L2 *ECS System Admin").Visible = False
.PivotItems("LAB Support").Visible = False
.PivotItems("LCO Support").Visible = False
.PivotItems("Logistics L2").Visible = False
.PivotItems("Manufacturing SAP").Visible = False
.PivotItems("MCOE L2").Visible = False
.PivotItems("MyOC support").Visible = False
.PivotItems("NA Procurement").Visible = False
.PivotItems("People Soft L2").Visible = False
.PivotItems("PI L2").Visible = False
.PivotItems("Proconnect Contractor support").Visible = False
.PivotItems("SMS Support").Visible = False
.PivotItems("Software Compliance").Visible = False
.PivotItems("Sourcing L2").Visible = False
.PivotItems("SRM").Visible = False
.PivotItems("Warehouse L2").Visible = False
End With

, however i want to find a way to select the group i want and if it is not available it should skip and select the rest of the groups, any help would really be appreciated...thanks in advance.