show hide specific lines based on multiple Excel values

[khuybers]

Dear Excel-wizards,

Hopefully someone can help me with my VBA-programming problem. I want to show specific Rows in a sheet based on values filled in 1 cell. For example:
When Cell A2 = "X" then show only the Rows that have "X" as value in Column A starting from Row 10 till Row 999.

So only a Hide function in the formula is not enough, it also has to have a VLOOKUP function in it. I hope I explained it clearly enough.

It would be really helpful for me, so I hope someone knows what to do! Thank you.

Kind regards,

Koen Huybersch

 

[Truiz]

Sub MamiQuienTuEre()

Dim j As String




ActiveSheet.Cells.EntireRow.Hidden = False


j = Cells(2, 1).Value




For i = 99 To 10 Step -1
    If Cells(i, 1) <> j Then
    Rows(i).EntireRow.Hidden = True
    End If
Next


End Sub