Sub CopierTexte()
Dim i As Integer
Dim ligneC As Integer
ligneC = 1
For i = 1 To 10
If Not IsNumeric(Cells(i, 1).Value) And Cells(i, 1).Value <> "" Then
Cells(ligneC, 3).Value = Cells(i, 1).Value
ligneC = ligneC + 1
End If
Next i
End Sub