Excel hide or show rows

Show or hide rows based on content

Sub HideOrShowRows()
    Dim A As Range
    Set A = Range("A1:A103")
    A.EntireRow.Hidden = False
    For i = 1 To 103
        If Cells(i, 1).Value <> "" And Cells(i, 1).Value = False Then
            Cells(i, 1).EntireRow.Hidden = True
        End If
    Next i
End Sub

=IF( IFERROR(( SEARCH( "thingimfinding", N56, 1)), 0) = 0, "False", "True")

You may also like...