Need to use AutoFilter on multiple tables within a single VBA code

[mallandroid]

I have created a very simple VBA code that automatically applies a filter on the single column I have filtered on a table, which I have named “BB.Tbl1”. However, I want the VBA to apply to multiple tables that are all on the same worksheet, so I want it to include my other tables named "BB.Tbl2" and "BB.Tbl3", and those tables are the exact same design and also have a single filter on the same column. My code works only for the first table, and it currently looks like this:

Private Sub Worksheet_Change(ByVal Target As Range)

Me.Range("BB.Org1").ListObject.AutoFilter.ApplyFilter

End Sub

Let me know how I can update the VBA to work for all 3 tables. Thanks!

 

[mallandroid]

I ended up solving the issue here. It appears that pointing to the "Me" object was causing the problem for me. By removing "Me" as the parent object at the beginning of the syntax, it allowed me to continue to repeat this code ad infintum for as many tables as I would need. So for example, the following VBA code now allows me to automatically re-apply filters to the 3 tables in my worksheet:

Private Sub Worksheet_Change(ByVal Target As Range)

Range("BB.Org1").ListObject.AutoFilter.ApplyFilter

Range("BB.Org2").ListObject.AutoFilter.ApplyFilter

Range("BB.Org3").ListObject.AutoFilter.ApplyFilter

End Sub