title: Excel VBA: How to paste a value in the first Cell of the last row of a table?
body: <p>This is my first post and I'm a beginner VBA programmer so please excuse the rookie question.</p>
  
  <p>I am trying to get paste a value in the last cell of the first column of a table. Up to now, I never used tables and the above was easy as I just used the Rows.Count function. Below is what I have Tried so far:</p>
  
  <pre><code>Sub Add2_TAP_Tracker()
  
  '\\ Add new line
  ActiveSheet.ListObjects("Table4").ListRows.Add AlwaysInsert:=True
  
  '\\ Paste Data in New Row
  Range("TAP!$C$8").Copy
  ActiveSheet.ListObjects("Table4").ListColumns(3).Range
  
  '--&gt;Something to select the last cell and past it...&lt;--
  </code></pre>
  
  <p>Any help will be appreciated !</p>
  
  <p>Thanks,</p>
  
  <p>Ollie</p>