Hi Erik,

Try:

If Range("AB20").Value = "N" And _
Application.CountIf(Range("W12:W80"), "Abe") = 0 Then


---
Regards,
Norman



"Erik K via OfficeKB.com" <u13156@uwe wrote in message
news:55d07a8f5c4f4@uwe...
I am trying to create a statement to the affect of:

If Range("AB20").Value = "N" and Range("W12:W80").Value < "Abe" Then

I cannot get this statement to run. Is it not possible to create a "not
equal to" statement listing a string of cells? i.e. "W12:W80" ?


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200510/1