View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default Problem with logical sentence


-----Original 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/

.


Try sometihng like this



MyCheck = Cells(NumFilas, 2).Value < "NAFF" Or Cells
(NumFilas, 2).Value < "NEQ" _ Or Cells(NumFilas, 2).Value
< "IBR"

If MyCheck = True then...
' ome
Else...
End If