Sub ConTroleLigne()
Dim i As Long
testDoublon = False
For i = 1 To UBound(tbl)
If tbl(i, 1) Like ligne(1, 1) And _
CDate(tbl(i, 2)) = CDate(ligne(1, 2)) And _
CDbl(tbl(i, 4)) = CDbl(ligne(1, 3)) And _
CInt(tbl(i, 5)) = CInt(ligne(1, 4)) Then
testDoublon = True: Exit For
End If
Next
End Sub