@Scott Craner
I want to highlight all the rows in a table where I don't know the column number but I know the table name. So can you tell me what the code is for dynamic table rows?
Range(Cells(a.Row, 1), Cells(a.Row, 6)).Interior.Color = currentColor