dl = ActiveSheet.Range("B" & Rows.Count).End(xlUp).Row
for i = 1 to dl
If Left(activescheet.Range("A" & i).Value,6) = "REGION" then activesheet.Row(i).delete
next i
Option Explicit
Sub Macro1()
Dim i As Long
For i = Range("A65536").End(xlUp).Row To 1 Step -1
If Not UCase(Cells(i, 1)) Like "REGION*" Then Rows(i).Delete
Next i
End Sub
Sub Tri()
[A:A].Copy [C1] 'facultatif et à adapter
[C:C].Replace "REGION", "0REGION", xlPart
[C:C].Sort [C1], xlAscending, Header:=xlNo
Range("C" & Application.CountIf([C:C], "0REGION*") + 1 & ":C" & Rows.Count).Delete xlUp
[C:C].Replace "0REGION", "REGION", xlPart
End Sub
Sub Tri()
Dim mot As String
mot = Application.Trim(InputBox("Entrez le mot :", "Mot"))
If mot = "" Then Exit Sub
[A:A].Copy [C1] 'facultatif et à adapter
[C:C].Replace mot, "0" & mot, xlPart
[C:C].Sort [C1], xlAscending, Header:=xlNo
Range("C" & Application.CountIf([C:C], "0" & mot & "*") + 1 & _
":C" & Rows.Count).Delete xlUp
[C:C].Replace "0" & mot, mot
End Sub
Sub Tri()
Dim mot As String
mot = Application.Trim(InputBox("Entrez le mot :", "Mot"))
If mot = "" Then Exit Sub
[C:C].ClearContents
With Range("C1:C" & [A65536].End(xlUp).Row)
.FormulaR1C1 = "=TRIM(RC1)" 'SUPPRESPACE
.Value = .Value 'supprime les formules
.Replace mot, " " & mot, xlPart
.Sort [C1], xlAscending, Header:=xlNo
Range("C" & Application.CountIf([C:C], " " & mot & "*") + 1 & _
":C" & Rows.Count).ClearContents
.Replace " " & mot, mot
End With
End Sub