1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| Option Explicit
Option Base 1
Sub texte_cherché()
Dim TbTexte, x As Long, y As Integer, mot As String, phrase, placer()
mot = InputBox("Quel mot cherché ?", "Mot D'apres", "les")
With Sheets("Fichier Publipostage")
x = .Range("Q" & .Rows.Count).End(xlUp).Row
TbTexte = .Range("Q2:Q" & x)
ReDim placer(1 To x)
For x = 1 To UBound(TbTexte)
phrase = Split(TbTexte(x, 1), " ")
For y = 0 To UBound(phrase)
If phrase(y) = mot Then
placer(x) = placer(x) & " " & phrase(y + 1)
End If
Next y
Next x
.Range("CT2:CT" & UBound(placer)) = WorksheetFunction.Transpose(placer)
End With
End Sub |
Partager