Sorry Brodyeva,
j'ai mal compris ta demande.
à tester
Sub Sub CopieTexte()
Dim myarray As Variant, r As Variant
Dim LastRow, i As Long
myarray = Array("test1", "test2", "test3", "test4", "test5", "test6", "test7", "test8", "test9", "test10", "test11", "test12", "test13", "test14", "test15", "test16", "test17", "test18", "test19", "test20")
LastRow = ActiveSheet.Cells(ActiveSheet.Rows.Count, "A").End(xlUp).Row
For i = 2 To LastRow
For Each r In myarray
If InStr(1, LCase(Cells(i, 1).Value), r) <> 0 Then
Cells(i, 2).Value = r
End If
Next r
Next i
End Sub