macro to hide all rows with specific text in column B.

[gaztr1x]

Hi, I am looking for a macro to hide all rows that have the word "detail" in column B. This will ultimately be assigned to a button. I feel like this should be an easy one, but I seem unable to get the If function to work. Any help is appreciated.

 

[gorem]

Hey - is this what you need?

Sub hide_rows()


    For i = 1 To ThisWorkbook.ActiveSheet.Range("B" & Rows.Count).End(xlUp).Row
    
        If ThisWorkbook.ActiveSheet.Range("B" & i).Value = "a" Then
            ThisWorkbook.ActiveSheet.Rows(i & ":" & i).Hidden = True
        End If
        
    Next i
    
End Sub

 

[gaztr1x]

Hey - is this what you need?

Sub hide_rows()


    For i = 1 To ThisWorkbook.ActiveSheet.Range("B" & Rows.Count).End(xlUp).Row
    
        If ThisWorkbook.ActiveSheet.Range("B" & i).Value = "a" Then
            ThisWorkbook.ActiveSheet.Rows(i & ":" & i).Hidden = True
        End If
        
    Next i
    
End Sub

Hi Thanks for that I will give it a try. However it dawned on me a couple of minutes ago, why don't I do this based on a filter. I have solved this a different way with the following code. Thanks again though

Sub hidedetails()
'
' hidedetails Macro
'
'
    ActiveSheet.Range("$A$5:$G$230").AutoFilter Field:=2, Criteria1:="Text"
    Sheets("New").Select
End Sub