Hello,

I have below code to add row. My data is in table format.

Dim ws As Worksheet
Set ws = ActiveSheet
Dim tbl As ListObject
Set tbl = ws.ListObjects("Sales_Table")
tbl.ListRows.Add 1
Whereas I have multiple sheets in table format. I need to add rows in every sheet.

Above code just adds the row in Active sheet and not in the other sheets. There are other sheets as well, like, Table1, Table 2, Table3 and so on.

Please assist. Thanks!