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