Merci de ton conseil,Bonjour
Je ne sais pas si ça peu dépanner... mais une copie écran peut peut-être t'aider... ?
Nak
Sub a()
Dim Sh As Worksheet, TuEsOu As Range, fa, k&
For Each Sh In ThisWorkbook.Worksheets
With Sh.UsedRange
Set TuEsOu = .Cells.Find(What:="toto")
If Not TuEsOu Is Nothing Then
fa = TuEsOu.Address
Do
resultat = resultat & Sh.Name & "| " & TuEsOu.Address(0, 0) & vbCrLf
k = k + 1
Set TuEsOu = .FindNext(TuEsOu)
Loop While Not TuEsOu Is Nothing And TuEsOu.Address <> fa
End If
End With
Set TuEsOu = Nothing
Next
MsgBox resultat, vbInformation, k & " cellule(s) trouvée(s)" & Space(9)
End Sub
If Not TuEsOu Is Nothing Then I LIKE