select entire row of clicked cell in a table

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

Please Login or Register  to view this content.

I would like to to then be able to highlight the entire row of the selected cell in the 'table1'.

Please Login or Register  to view this content.

Many Thanks

try

Please Login or Register  to view this content.

that unfortunately highlights entire worksheet row and not just the row of the selected table.

Is your table a set range or does it change?

If it is indeed static then you can hard code the correct range:

Please Login or Register  to view this content.

(columns C & H chosen at random for example purposes)

yeah its a fixed range
formula provided works . only if it were simpler like column selection 'Range("Table5[Notes]").Select'

Thanks Anyway!