title: How to find and return a column index in VBA?
body: <p>I am creating a VBA code to clear some data from multiple excel files. The problem is that the positions of the headers are not fixed and the columns slip away when I put together the files. 
  I have to find the column index based on header name and assign them to variables.</p>
  
  <p>I declared the range of the header to a variable.
  <strong>How can I return the column index to a variable?</strong> 
  I have never done this before that is why I am asking you guys.
  At my first attempt I was thinking something like this:</p>
  
  <pre><code>Set findrng = sourceWS.Range(Cells(1, 1), Cells(1, 100))
  index1 = findrng.Find("COUNTRY")
  </code></pre>
  
  <p>index1 should store an integer like 1 or 21 ...</p>
  
  <p>Any help would be appreciated.</p>