Thank you for the replies.

I will try the above and see how it works for me. I will get back to
you with results.

In reply to Chip Pearson, I cant use Conditional Formatting because
each time a blank cell in the range has a value input into it in the
range, they would be formatted automatically from the conditional
formatting. I only need them highlighted after the macro is run but
not every time a value is entered. I know it seems confusing when I
read it myself.


--
EJS
------------------------------------------------------------------------
EJS's Profile: http://www.excelforum.com/member.php...o&userid=34918
View this thread: http://www.excelforum.com/showthread...hreadid=546565