Put this in the code module for the sheet of interest and a row will be hidden every time that the entry in column D is removed. I'm not sure about this kind of routine. It is an awful lot of hassle to re-enter something in column D. Perhaps Autofilter would be another way to get what you want.
Private Sub Worksheet_Change(ByVal Target As Range)
If 4 = Target.Column And "" = Target.Value Then
Target.EntireRow.Hidden = True
End If
End Sub
P.S. This checks if there is a value in column D, I just noticed that the title said if value is zero. Which do you want to trigger the hiding, no value in column D or zero in column D?
Bookmarks