title: If statement to use column header name instead of column number?
body: <p>In my VBA code in Excel I wrote a bunch of stuff like: </p>
  
  <pre><code>If Worksheets("Original Data").Cells(i, 7) &lt;&gt; "" Then 
      'do stuff.
  </code></pre>
  
  <p>The <code>i</code> is the iterator for the row number the loop is on. The 7 was* the column number for a specific column, but now in a new "original data" sheet I received this column is in a different place.  Is there a way to replace the 7 with the column header name instead so it doesn't break every time the columns change position?</p>