Sub test_ligne_01()
Dim i As Integer
Dim valeur as Integer
For i = 1 To 5
If IsNumeric(Application.HLookup(Cells(2, i), Feuil1.Range("C2:V2"), 1, False)) Then valeur = valeur + 1
Next i
MsgBox valeur
End Sub
Ce message est de : http://excel.veriti.net/modules/newbb/viewtopic.php?post_id=595