If A5 is zero then this will hide row 5

Private Sub Worksheet_Change(ByVal Target As Range)
If Cells(5, 1).Value = 0 Then
Rows("5:5").Select
Selection.EntireRow.Hidden = True
End If
End Sub

"algebroni" wrote:

Is there a way i can hide or delete a whole row if the sum of the cell is = 0
example if A5=0 delete or hide the whole row. Thanks