jeudi 30 juillet 2015

Excel VBA If not equal not working

I have this problem where my code doesn't check if cell has the value I need. I used box to check value it look good from box, but if doesn't take value. Any ideas whats wrong? I tried add value manually to cells, but if does't working.

If ThisWorkbook.ActiveSheet.Cells(virsus, desinen).value <> "CH" Or ThisWorkbook.ActiveSheet.Cells(virsus, desinen).value <> "SSC" Then 
   If ThisWorkbook.ActiveSheet.Cells(virsus, desinen - 1).value <> "CH" Or ThisWorkbook.ActiveSheet.Cells(virsus, desinen - 1).value <> "SSC" Or ThisWorkbook.ActiveSheet.Cells(virsus, desinen - 1).value <> "" Then  
       MsgBox ThisWorkbook.ActiveSheet.Cells(virsus, desinen - 1).value

Aucun commentaire:

Enregistrer un commentaire