Bonsoir
Je te propose un autre code à améliorer
Function RechTous(v, champRech As Range, ChampRetour As Range, Separateur As String)
Dim Msg As String
Dim J As Long, I As Integer
Application.Volatile
' Vérification des données entrées
' code à faire
For J = 1 To champRech.Rows.Count
For I = 1 To champRech.Columns.Count
If champRech.Cells(J, I) = v Then
Msg = Msg & Separateur & ChampRetour.Cells(J, 1)
Exit For
End If
Next I
Next J
RechTous = Mid(Msg, Len(Separateur) + 1)
End Function