View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Problem with logical sentence

At least two of the conditions will always be true. Change your OR to AND I
think.

--
Regards,
Tom Ogilvy

cecilia12345 wrote in message
...
i have this conditional sentence
If Cells(NumFilas, 2).Value < "NAFF" Or Cells(NumFilas, 2).Value <
"NEQ" _
Or Cells(NumFilas, 2).Value < "IBR" Then

....

end if

however, the conditions are ignored when the program is running...
why?


---
Message posted from http://www.ExcelForum.com/