title: How to refer to a column in a Range by it's name
body: <p>I got a table in Excel to which I add a row. I then reference that row and am able to store values in the columns, by using numbers.</p>
  
  <pre><code>Dim table As ListObject
  Dim lastRow As Range
  
  Set table = sheet.ListObjects.Item("TagTable")
  table.ListRows.Add
  Set lastRow = table.ListRows(table.ListRows.Count).Range
  lastRow(1) = "Value for column 1"
  lastRow(2) = "Value for 2"
  </code></pre>
  
  <p>Problem with this is that it isn't very flexible. I'd rather address the column name. I am searching like crazy, but I can't find any info on how to achieve this. Is this even possible or am I doing something crazy with this code?</p>