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

• › How to move multiple folders in Outlook?
• › [Solved] Use FIND to Select multiple words in document
• › [Solved] VBA macro to copy multiple columns in user defined order
• › [Solved] VBA to Stack The Data in Two Columns
• › Wanted to delete multiple images in Excel 2007
• › Need help! Ability to chose multiple items from a dropdown
• › [Solved] Selecting specific emails to email through vba