Hi, im trying to write a simple if statement such as

If Not sCode = "" or "abc" OR "xyz" Then
'' do the main piece of code here


ElseIf sCode = "abc" OR "xyz" Then

alternative piece of code.

end if

sCode is text read from a cell, the code does not like having the O
statement and displays error message 13 mismatch in data.
What is going on? im sure this was working earlier!

--
cereldin
-----------------------------------------------------------------------
cereldine's Profile: http://www.excelforum.com/member.php...fo&userid=3206
View this thread: http://www.excelforum.com/showthread.php?threadid=53092