If Target.Value Like "*/*" = False Then
lng = Len(Target): gtin = Target.Text
gtin = Mid(Target.Text, 3, 14)
lg = Application.Match(gtin, Feuil2.[A:A], 0)
If Not IsNumeric(lg) Then MsgBox "Non trouv?": GoTo fin
If IsNumeric(Feuil2.Cells(lg, 2)) Then
lig = Application.Match(Val(Feuil2.Cells(lg, 2)), Feuil1.[A:A], 0)
Else
lig = Application.Match(Feuil2.Cells(lg, 2), Feuil1.[A:A], 0)
End If
If Not IsNumeric(lig) Then MsgBox "inexistant": GoTo fin
If lng < 29 Then lot1 = Mid(Target, 19, lng) Else lot1 = Mid(Target, 27, lng)
Application.EnableEvents = False
Cells(lig, 7) = lot1: Cells(lig, col) = Cells(lig, col) + 1: Target = "": Beep
Target.Select
Application.EnableEvents = True
GoTo fin
End If