title: VBA refer to PivotTable column by its SourceName
body: <p>How to select PivotTable column by its <code>.SourceName</code>? Or how to get the SourceName of PivotTable column based on ActiveCell.Column? I need something like:</p>
  
  <pre><code>ActiveSheet.PivotTables(1).SourceName("MyColumn").Select
  </code></pre>
  
  <p>The reason why I need it is because the pf.Caption changes dynamically (i.e. due to Country settings), while the <code>.SourceName</code> is always the same. </p>