title: Set all cells in a table column to a specific value
body: <p>I'm currently working on a data set which is formatted as a table, with headers.  What I need to do is cycle through all cells in a specific column and change the contents.  Through research on MSDN I came up with the following for loop</p>
  
  <pre><code>for i = 1 to NumRows
      Cells(i,23).Value = "PHEV"
  next i
  </code></pre>
  
  <p>So this would change all the cells in column 23 to read "PHEV".  However, I do not build the table I'm working with myself, so I can't guarantee that the column I'm interested in will be column 23.</p>
  
  <p>I'd like to implement something similar to the following:</p>
  
  <pre><code>for i = 1 to NumRows
      Cells(i,[@[columnHeader]]).Value = "PHEV"
  next i
  </code></pre>
  
  <p>Of course, I know that that syntax is incorrect, but hopefully it sufficiently illustrates my goal.</p>