title: How to select Specific known values in Multiple items in Pivot table using VBA
body: <p>I want select only specific set of values in the pivot table</p>
  <pre><code>ActiveSheet.PivotTables(&quot;PivotTable&quot;).PivotFields(&quot;Opened by&quot;).CurrentPage = _
          &quot;(All)&quot;
      With ActiveSheet.PivotTables(&quot;PivotTable&quot;).PivotFields(&quot;Opened by&quot;)
          .PivotItems(&quot;&quot;) = False
          .PivotItems(&quot;Abilash&quot;).Visible = True
          .PivotItems(&quot;Adrien&quot;).Visible = True
          .PivotItems(&quot;AJAY&quot;).Visible = True
          .PivotItems(&quot;Akanksha&quot;).Visible = True
          .PivotItems(&quot;Akash&quot;).Visible = False
      
  </code></pre>
  <p>Kindly give me entire code to select the field, table and get it done right front.</p>
  <p>I find it really difficult to find the right code to get the simple thing done. I find vb difficult on this front.</p>