Sub test()
Dim Cell As Range, Sadr As String
With [Feuil2!Q8:Q50]
Set Cell = .Find("*", [Feuil2!Q50], xlValues, xlWhole)
Do While Not Cell Is Nothing
If Sadr = "" Then Sadr = Cell.Address
[Feuil3!A2] = Cell.Value
Imprime2
Set Cell = .FindNext(Cell)
If Cell.Address = Sadr Then Set Cell = Nothing
Loop
End With
End Sub