title: Pivot table filter raises error when empty
body: <p>.I have multiple pivot tables. When I open the workbook, I am forcing excel to select filters using:</p>
  
  <pre><code>Sheets("PSD").Select
  'Update table 7 Number of PSDs scheduled by Month
      ActiveSheet.PivotTables("PivotTable7").PivotFields("Adhoc").CurrentPage = _
      "No"
      ActiveSheet.PivotTables("PivotTable7").PivotFields("Type").CurrentPage = _
      "PSD Inspection"
  'Update table 8 Number of PSDs scheduled by Month
      ActiveSheet.PivotTables("PivotTable8").PivotFields("Adhoc").CurrentPage = _
      "No"
      ActiveSheet.PivotTables("PivotTable8").PivotFields("Type").CurrentPage = _
      "PSD Inspection"
  </code></pre>
  
  <p>The problem is when there is no data with that filter as expected, I am getting an error. </p>
  
  <p>How can I create a condition where I check if the filter exists and if it does, force the filter to what I want, else skip it. </p>