1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| Option Explicit
Option Compare Text
Sub es()
Dim s, a As Variant, Message As String, i As Long
Cells.EntireRow.Hidden = False
Application.ScreenUpdating = False
s = InputBox(Message, " donnees a visualiser")
If s = "" Then Exit Sub
Set a = Range("d1:d" & Cells(Rows.Count, 4).End(xlUp).Row).Find(What:=s)
If a Is Nothing Then
MsgBox "le nom recherche ne figure pas dans la liste"
es
Else
For i = 1 To Cells(Rows.Count, 4).End(xlUp).Row
If Cells(i, 4) <> s Then Rows(i).EntireRow.Hidden = True
Next i: End If
End Sub |
Partager