Hello,
I have below code to add row. My data is in table format.
Whereas I have multiple sheets in table format. I need to add rows in every sheet.![]()
Dim ws As Worksheet Set ws = ActiveSheet Dim tbl As ListObject Set tbl = ws.ListObjects("Sales_Table") tbl.ListRows.Add 1
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!
Bookmarks