VBA code to select the bottom left cell of my table!!!!

[Pjh5473]

Hi so I have a table on an excel sheet and I am trying to get the table to add a new row, then select the leftmost cell in that new row (because I have a userform and that's where I want to start inputting the data).
Here is my code so far.:

Private Sub cmdADD_Click( )
Sheets("Database").Activate
ActiveSheet.ListObjects("Table1").ListRows.Add AlwaysInsert=True

?????????????????????????????????????

ActiveCell.Value=txtCompoundRep.Value
ActiveCell.Offset(0,1).Value=txtTA.Value
End Sub

I need help figuring out what goes where all the ?????????????? are that will select the leftmost cell of the newly created row in my table so that the inputs of the userform go where they are supposed to!!!!!

 

[Fluff]

Hi & welcome to MrExcel.
How about

   With Sheets("Database").ListObjects("table1").ListRows.Add
      .Range(1).Value = txtCompoundRep.Value
      .Range(2).Value = txtTA.Value
   End With

 

[Pjh5473]

YESSSS THANK YOU!!!! You are the best. It works. Just for reference I can keep going with range(3) range(4) etc. right? and if I need to skip a cell I can just skip a number???

 

[Fluff]

That's right