Oups un peu rapide le copié collé !!
Sub Test ()
Dim r as Range
Dim msg As String
If Worksheets("Sheet1").AutoFilterMode Then
Worksheets("Sheet1").AutoFilterMode = False
Worksheets("Sheet1").Range("A1").AutoFilter Field:=3, Criteria1:="OUI"
Else
Worksheets("Sheet1").Range("A1").AutoFilter Field:=3, Criteria1:="OUI"
End If
Set r = Sheets("Sheet1").Range("A2:" & Sheets("Sheet1").Range("A65536").End(xlUp).Address)
Set r = r.SpecialCells(xlCellTypeVisible)
If r.Count = 1 Then 'Considération du "Heading"
MsgBox "LIGNE NOT OK"
Exit Sub
End If
msg = "AutoFilter valeur retournée sur ligne(s)" & vbCrLf
For Each Cell In r
If Cell.Row > 1 Then
msg = msg & Cell.Row & vbCrLf
End If
MsgBox msg, vbInformation, "Ligne(s) Matching "
End Sub
Sorry !
@+Thierry