I don't want to have to press "Alt F8" to hide 0 value rows and unhind rows >0
I want it to Do it Automatically as the data changes.
This is the VBA code that works to hide/unhide rows with a value of 0, but again, it does not work automatically but rather manually.
Sub HideRows()
Application.EnableEvents = True
On Error Resume Next
For Each c In Range("V13:V898")
If c.Value = 0 Then
c.EntireRow.Hidden = True
ElseIf c.Value >= 0 Then
c.EntireRow.Hidden = False
End If
Next
On Error GoTo 0
Application.EnableEvents = True
End Sub
Worksheet.Changeevent. – Mathieu Guindon Jan 15 '19 at 18:27