[Dba-office] Excet Table with VBA

[Susan Harkins]

I can add a new row to an Excel Table using the following line of code:

 

 
ThisWorkbook.Worksheets("DataValidation").ListObjects("Table1").ListRows.Add
AlwaysInsert:=True

 

But for the life of me I can't figure out how to add a value to the new row!
I've read all day and I can find all kind of articles on the above - but
nothing on how to add a value to that new row. 

 

Susan H.