Thanks that works a treat. But how about if I wanted to just color a
selectrange to change color rather than the entire row i.e. just the
cells along that row with in the table, say B:AB.
Can I just modify that bit of code or is it more complex than that?

Again I thank you..


--
titch
------------------------------------------------------------------------
titch's Profile: http://www.excelforum.com/member.php...o&userid=31190
View this thread: http://www.excelforum.com/showthread...hreadid=556271