Is your table a set range or does it change?

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


range("C" & target.row & ":" & "H" & target.row).interior.color = 12611584
(columns C & H chosen at random for example purposes)