Hello everyone,
I have this if statement that keeps returning a "Run Time" error 13 (type mismatch), and I can't figure out why.
Here it is (embedded in a for loop)
/*For i = 6 To 2000
If Cells(i, 5).Value = tr.Cells(x, 7).Value And Cells(i, 4).Value = tr.Cells(x, 4).Value Then
outcome = "TRUE"
End If
Next i
*/
I have initialized my variables like such:
x = 3
Dim i As Integer
Set tr = Sheets("TRACKING")
Does anyone know why this is happening?
Thanks a lot,
Corentin
Bookmarks