Sub test()
Dim a, i, imax, arr, row0
a = Cells(60000, 1).End(xlUp).Row
arr = [a1].Resize(a, 3)
For i = 1 To a
If InStr(1, "cc", arr(i, 3)) > 0 Then
If arr(i, 1) > imax Then imax = arr(i, 1): row0 = i
End If
Next i
Cells(row0, 2) = "OK"
End Sub
Sub test()
Dim a, i, imax, arr, row0
a = Cells(60000, 1).End(xlUp).Row
arr = [a1].Resize(a, 3)
For i = 1 To a
If InStr(1, "cc", arr(i, 3)) > 0 Then
If arr(i, 1) > imax Then imax = arr(i, 1): row0 = i
End If
Next i
Cells(row0, 2) = "OK"
End Sub