title: How to get the values when multiple items are selected in PivotTable PageField?
body: <p>I am rying to ge the values of PivotField in PivotTable(1).Pivotfields, then I am trying to get the the filter value to string(str- Declared as string), It is working fine, but when I select multiple items in filter, <code>"(All)"</code> value is passed to str.</p>
  
  <p>How to pass the value of selected items(more than one) in pivot items.</p>
  
  <pre><code> For Each PF In PT1.PivotFields
   If PF.Orientation = xlPageField Then
      str = PF.CurrentPage
   PT2.PivotFields(PF.Name).CurrentPage = str
  </code></pre>
  
  <p>Below is the snap of values I need to pass to str.   </p>
  
  <p><img src="https://i.stack.imgur.com/oXt2o.jpg" alt="enter image description here">  </p>
  
  <p>Any help will be greately appreciated.</p>