Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo Fin
If Target.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("A1")) Is Nothing Then
Ligne = 1 + Application.Match([A1], Range("A2:A65000"), 0)
[B1] = "Ligne " & Ligne
Range("A" & Ligne).Select
End If
Fin:
End Sub