title: Reference a cell by its column name
body: <p>I want to update the contents of a cell in a workbook. My code looks a little like this:</p>
  
  <pre><code>ProductionWorkBook.Sheets("Production Schedule").Cells(StartRow, 1).Value = EstJobName(i)
  </code></pre>
  
  <p>The cells are referenced using <code>Cells(StartRow, 1)</code> Where StartRow was a pre-declared and pre-defined integer variable that specifies the row and "<code>1</code>" denotes the column.</p>
  
  <p>EDIT: 
  Now, I want to change this code to reference the columns by the <strong>column HEADERS</strong> instead.</p>
  
  <p>For example, the header of a column is: "Fab Hours Date", how do I reference that?</p>