Sorry, I got it ten minutes after posting. Just placing
Code
-------------------
Color = UCase(Color
-------------------
at the start will work
--
d.i.bar
-----------------------------------------------------------------------
d.i.barr's Profile:
http://www.excelforum.com/member.php...fo&userid=1552
View this thread:
http://www.excelforum.com/showthread.php?threadid=38126