Hi guys,

In my vba code I want to add another statement to say to say somethin
like:


Code
-------------------


If (Status1 = "n/a") And Status2 = "System Error" Like "?System*" Then

MyStatus = "System Error"


-------------------


Basically if status2 contains System error then MyStatus = "Syste
Error"

Thanks for your help

--
harpscardif
-----------------------------------------------------------------------
harpscardiff's Profile: http://www.excelforum.com/member.php...fo&userid=2596
View this thread: http://www.excelforum.com/showthread.php?threadid=47503