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
Bookmarks