I have been trying variations of this formula with no luck. Other ways have been successful in highlighting entire row of worksheets but I'm looking to target only the entire row of the table of the selected cell.

After this determines whether the selected cell is in the required table

  
    If Not Intersect(Target, Range("Table3")) Is Nothing Then
    
       
(Formula for entire row selection)
       
    Else
    
    do Nothing

        
    End If
I would like to to then be able to highlight the entire row of the selected cell in the 'table1'.
 sel = ActiveCell.EntireRow
   
   Range(sel).Selection.Interior.Color = 12611584
Many Thanks