VBA to select multiple items in pivot table field list

Hi, I have a workbook with one main tab and 16 other tabs (mainly charts that are derived from pivots). The source of all pivots is the main tab. In the main tab, one of the fields is a “Status” field that changes almost daily. "Status" is one of the pivottable field list. I use "select multiple items" within this field list to select the Statuses relevant to the metrics I want. I want to create a macro that would look at the options under the Status field list and select the items I want if they are visible. I have the following macro so far, but the problem is if one of these statuses is not active and thus is not in the main tab the macro runs into a bug because it can’t find it among the options available under Status in the field list. I believe the solution would be a macro based on “if/then” that says if this reporting filter exists then select it in the report filters options. I would appreciate the help. With ActiveSheet.PivotTables("PivotTable1").PivotFields(" Status") .PivotItems("Phase 1 - Review+").Visible = True .PivotItems("Phase 1 - CWG+").Visible = True .PivotItems("Phase 5 - PIAR Review+").Visible = True .PivotItems("Phase 2 - Kickoff+").Visible = True .PivotItems("Phase 3+").Visible = True .PivotItems("Phase 4+").Visible = True .PivotItems("Phase 5+").Visible = True .PivotItems("Phase 5 - Implementation+").Visible = True

• › [Solved] VBA macro to copy multiple columns in user defined order
• › Need help! Ability to chose multiple items from a dropdown
• › VBA Code for Data Validation multiple selecion setup
• › [Solved] How to Use Dymo Label in my VBA
• › How to search multiple value in a single cell in excel
• › How to move several folders in Outlook?
• › [Solved] VBA to apply a vlookup but prompts for a file name?