Is your table a set range or does it change?
If it is indeed static then you can hard code the correct range:
(columns C & H chosen at random for example purposes)![]()
range("C" & target.row & ":" & "H" & target.row).interior.color = 12611584
Is your table a set range or does it change?
If it is indeed static then you can hard code the correct range:
(columns C & H chosen at random for example purposes)![]()
range("C" & target.row & ":" & "H" & target.row).interior.color = 12611584
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks