Sub TRIER()
Dim Lig As Variant
Lig = Application.Match(0, Range("A4:A14"), 0)
If IsError(Lig) Then
Range("E1").Value = 14
Range("A4:D14").Sort Key1:=Range("A4"), Order1:=xlAscending
Else
Range("E1").Value = Lig + 2
Range("A4:D" & Lig + 2).Sort Key1:=Range("A4"), Order1:=xlAscending
End If
End Sub