I have a table with products and I want to hide the row if said product can be found in a different table.
So for each row of table 1 check if value in column A can be found in Table 2 column A and if yes hide that row in table 1.

I have this code I am using as base, but I have yet to figure out how to refer to the second table column 1 for checking.

```
For Each row In myTable.DataBodyRange.Rows
    If row.Cells(1, 1).Value = 'can be found in column A table 2 Then
       row.Hidden = True
    End If
Next

```

EDIT:

My final working code provided by @Vityata for anyone interested:

```
Public Sub TestMe()

    Dim tbl1 As ListObject
    Set tbl1 = ActiveSheet.ListObjects("Table1")

    Dim tbl2 As ListObject
    Set tbl2 = ActiveSheet.ListObjects("Table2")

    Dim myRow As Range

    For Each myRow In tbl1.DataBodyRange.Rows
        If Not myRow.Cells(1, 1).EntireRow.Hidden Then
        Dim hideMe As Variant
        hideMe = Application.Match(myRow.Cells(1, 3).Value2, tbl2.Range.Columns(1).Cells, 0)
        If IsError(hideMe) Then hideMe = False
        myRow.Cells(1, 1).EntireRow.Hidden = hideMe
        End If
    Next myRow

End Sub

```