Bonsoir,
-Le mot FINI n'apparaît pas
- Essai avec extraction du mot carte en colonne 4
- 0,04 sec pour 1000 lignes
Sub ExtraitLignesMot()
Set f = Sheets("feuil1")
mot = "carte": colonne = 4
Application.DisplayAlerts = False
Application.ScreenUpdating = False
bd = f.Range("A1:F" & f.[A65000].End(xlUp).Row)
mot = "*" & mot & "*"
For i = 1 To UBound(bd)
If bd(i, colonne) Like mot Then temp = temp & i & ","
Next i
a = Application.Index(bd, Application.Transpose(Split(temp, ",")), Array(1, 2, 3, 4, 5, 6))
f.Cells(ligne + 1, "k").Resize(UBound(a) - 1, UBound(a, 2)) = a
End Sub
Ceuzin