'...
Dim L As Long
N_Test = Selection_Test.Value
Set cell_ligne = ActiveSheet.Range("B3:B32").Find(N_Test)
If Not cell_ligne Is Nothing Then
L = cell_ligne.Row
Range(Cells(L + 1, 2), Cells(L + 1, 2).End(xlDown).Offset(, 1)).Copy
Cells([COLOR="Red"][B]L[/B][/COLOR], 2).PasteSpecial Paste:=xlValues
End If
End Sub