Bonjour,
Une autre proposition à étudier.
Un petit bonjour à Theze.
Cdlt.
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
Dim N As Long, rng As Range, p As Long
If Target.Address = "$H$2" Then
If IsEmpty(Target) Or Not IsNumeric(Target) Then Exit Sub
If Target.Value < 1 Or Target.Value >= 150 Then Exit Sub
End If
With Me
N = .Cells(.Rows.Count, 1).End(xlUp).Row
Set rng = .Cells(1).Resize(N)
On Error Resume Next
p = Application.Match(Target.Value, rng, 0)
If Err.Number <> 0 Then
Err.Clear
MsgBox "Le dossard " & Format(Target.Value, "000") & " est inconnu !..."
Exit Sub
Else
.Cells(p, 8).Value = Target.Value
End If
End With
End Sub