Automaticall Hide Rows based on column value

[NotSwank]

I want to have a VBA Code that automatically updates when a value in C1:C2088 changes. It should only care about cells with "hide" in them. These cells do have formulas in them that display either hide or "".

What I have currently that isn't working is:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
 Dim cell As Range
    
    For Each cell In Worksheets("NAV Import").Range("C1:C2088")
        If cell.Value = "hide" Then
             cell.EntireRow.Hidden = True
        Else
            cell.EntireRow.Hidden = False
        End If
        Next cell
End Sub

[JOHN H. DAVIS]

I think you need a Change Event instead of SelectionChange? Is Sheet "NAV Import" the activesheet? Or is it a separate sheet?

[NotSwank]

It's not necessarily the active sheet. Most of the work is being done on another sheet, which triggers changes on this sheet.