VBA Code (Hide Rows)

[Range]

Hi,

I need some VBA code to hide some rows depending on a ">0" criteria in column P.

Thanks

 

[Michael M]

If you want it "= 0 " then remove the greater than sign in the code

Public Sub HideRows()
Dim i As Integer
For i = 31 To 13 Step -1
    If Range("P" & i).Value = 0 Then
    Rows(i).EntireRow.Hidden = True
    End If
Next i
End Sub