Bonjour saaku, le forum,
Je ne connais pas l'utilisation de Showdetail, mais un truc du genre:
Dim Cell As Range, Titres, i As Integer, derlig As Integer, lig As Integer
Titres = Array("Gum", "Gam", "Gym", "Gom") 'tes conditions
derlig = Range("A" & Rows.Count).End(xlUp).Row
Application.ScreenUpdating = False
For i = 0 To UBound(Titres)
For lig = 1 To derlig
If Cells(lig, 1).Value = Titres(i) Then '................traitement
Next lig
Next i
Erase Titres
A tester...
Cordialement,