I've always had this problem, and have solved it by simply doing:
If Range("b7").Value<> "Telephone Support" Or Range("b7").Value<> "Warranty Parts" Then
So, you can't just string OR's on to the end, it has to be comparing directly.
This message was edited by OdinsDream on 2002-07-26 10:46