elmnas
05-27-2015, 01:18 AM
Hello guys I made this code so far
but I do specify the last cell but I want instead the script loops to the last used cell
Could someone help me to modify the code a bit?
Thank you in advance
See code below:
Sub CheckMatch()
For i = 2 To 230 ' I Want to modify this part
If Cells(i, "J") = Cells(i, "K") And Len(Cells(i, "B")) <> 0 And Cells(i, "AB") <> 0 Then
MsgBox "Row " & i & " match"
End If
Next i
End Sub
but I do specify the last cell but I want instead the script loops to the last used cell
Could someone help me to modify the code a bit?
Thank you in advance
See code below:
Sub CheckMatch()
For i = 2 To 230 ' I Want to modify this part
If Cells(i, "J") = Cells(i, "K") And Len(Cells(i, "B")) <> 0 And Cells(i, "AB") <> 0 Then
MsgBox "Row " & i & " match"
End If
Next i
End Sub