Sub e()
monclientpro = "oui"
derlig = Sheets("feuil1").Range("A" & Rows.Count).End(xlUp).Row
If monclientpro = "oui" Then
Range("A" & derlig + 1).Value = Range("maxpro").Value + 1
Else
Range("A" & derlig + 1).Value = Range("maxpart").Value + 1
End If
End Sub