Sub Sup()
Dim x$, nf%, i%, c As Range, n%
x = "test de suppresion" 'faute d'orthographe !!!
nf = Worksheets.Count
Application.ScreenUpdating = False
Application.DisplayAlerts = False
On Error Resume Next
For i = nf To 1 Step -1
Set c = Worksheets(i).Cells.Find(x, , xlValues, xlPart)
If c Is Nothing Then n = n + 1: Worksheets(i).Delete
Next
If Err Then n = n - 1
MsgBox n & " feuille(s) sur " & nf & " supprimée(s)" & IIf(Err, ", la dernière ne peut l'être !", "")
End Sub