title: Get column number by cell value in Excel
body: <p>I'm trying to get the column number of a cell in the first row with a specific value.  The code I'm using isn't working for some reason.</p>
  
  <pre><code>Dim colNum As Integer
  'sheetName is a String
  With ActiveWorkbook.Sheets(sheetName)
  colNum = column(.Match("ID", 1:1, 0))
  </code></pre>
  
  <p>It's telling me it's expecting a "list separator or )".  How do I make it work?</p>
  
  <p>Thanks</p>