Comparing String Values
 

Hello!

Try:
If NOT(Value_of_Cell = Title) Then Broken = True

You can't negate a string variable afaik.

What should also work is:
Broken = NOT(Value_of_Cell = Title)

Ro

--
Message posted from http://www.ExcelForum.com