Hide all rows in a range with no value

[hamistasty]

I want to hide the entirerow of each row in the range C13:C20 with the value of 0. So every cell that has no value in column C, from row 13 to 20, I want to hide.

Appreciate any help

 

[Yahya]

Try this

Sub Test()
Dim c As Range
For Each c In Range("C13:C20")
    If c.Value = vbNull Or c.Value = 0 Then
        c.EntireRow.Hidden = True
    End If
Next c
End Sub

 

[John Davis]

I want to hide the entirerow of each row in the range C13:C20 with the value of 0. So every cell that has no value in column C, from row 13 to 20, I want to hide.

Appreciate any help

Another option:

Sub hamistasty()

With Range("C13:C20")

    .AutoFilter Field:=1, Criteria1:="<>0"
    
End With

End Sub

Or without code:

Data>Filter>AutoFilter>Custom>Does not equal>0