Hiding rows based on a cells value (Macro)

[skyfury]

Hi, I am a VBA beginner, trying to figure out how to hide rows based on the value of a cell. I have seen similar posts that did not quite answer what I am trying to do.
If cell A3 = "Brand", I want to hide all rows where C9:C2000 NOT= "Brand"
Else if cell A3 = "Other", I want to hide all rows where C9:C2000 NOT= "Other"
Else if cell A3 = "All", don't hide any rows

This is what I tried... what am I doing wrong?

Sub hiderows2()


For Each d In Range("C9:C2000")
If Range("A3").Value = "Brand" Then Rows(d.Row).Hidden = True
Else: If Range("A3").Value = "Other" Then Rows(d.Row).Hidden = True
Else: Rows(d.Row).Hidden = False
Next


End Sub

Thank you!

 

[johnsterne]

You could easily just use a filter. Then you can select the column and choose what options you want to view without VBA. Let me know if this helps.

Excel Filter - Easy Excel Tutorial

 

[skyfury]

Thanks, but this will be in a canned report for management, they prefer to just push a button than filter... looking for how to do it in VBA.