Excel table VBA - Select new last row cell 2 as active
<p>I have the following code. It does not select the newly created row...</p>

<p>I have a macro button called ADD NEW which links to code that successfully adds a new last row in a table and generates a new number in the first cell of the table. but it does not set as active and 'go to' the second cell to begin user ....
what am I missing?</p>

<pre><code>Sub Add_New()

Dim the_sheet As Worksheet
Dim the_table As ListObject
Dim table_object_row As ListRow
Dim last_row As Long

Set the_sheet = Sheets("Inventory")
Set the_table = the_sheet.ListObjects("tbl_Data")
Set table_object_row = the_table.ListRows.Add
Set last_row = the_sheet.Range("C1`" &amp; .Rows.Count).End(x1up).Row
End Sub
</code></pre>