Thanks for the quick response Tom!

I dropped that snippet in and got a "Runtime Error '13': type
mismatch" error.

I am not quite sure why I am getting this (I have only written a few
macros with tons of help from the mvps on this site and I am still
getting my arms around VB).

I changed my original line to this:

If ActiveCell.Value = Evaluate("OR(EXACT(" & ActiveCell.Value &
",DropDown))") = False Then

did I mess something up?


--
Celt
------------------------------------------------------------------------
Celt's Profile: http://www.excelforum.com/member.php...o&userid=19413
View this thread: http://www.excelforum.com/showthread...hreadid=522022