Thread: If Not equal to statements
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Erik K via OfficeKB.com[_2_] Erik K via OfficeKB.com[_2_] is offline
external usenet poster
  
Posts: 15
Default If Not equal to statements
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
Reply With QuoteReply With Quote