Hi
I have a spread sheet with some linked cells - column E.
What I would like to do is hide the entire row if it contains a 0-
EG if E5 = 0 then hide row 5 , I have tried this (and various other variations )
Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Range("E9:E30").Value = 0 Then EntireRow.Hidden = True End If End Sub
Bookmarks