Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionWith Worksheets(1).Range("a1:a500") Set c . Find (2, lookin:xlValues) If Not c Is Nothing Then firstAddress = c.Address Do c.Interior.Pattern = xlPatternGray50 Set c = .FindNext(c) Loop While Not c Is Nothing And c.Address <> firstAddress End If End With donc si tu adapte les adresse, tu pourra trouver tes données A+ louis
With Worksheets(1).Range("a1:a500") Set c . Find (2, lookin:xlValues) If Not c Is Nothing Then firstAddress = c.Address Do c.Interior.Pattern = xlPatternGray50 Set c = .FindNext(c) Loop While Not c Is Nothing And c.Address <> firstAddress End If End With J'espère que ce serra plus lisible