Below is a macro that we use in Excel. Its purpose is to hide rows whose dollar amounts are $0.00.
Even though it is conducting that task very well, it is also hiding all rows that were blank to begin with - not just rows having $0.00 amounts.
How do I modify this syntax to still display rows that were completely empty in the first place?
If it helps, I just added "Before" and "After" screenshots showing the issue more prominently.
On Error Resume Next
Dim i As Integer
Dim j As Integer
Dim WS As Integer
Application.ScreenUpdating = False
WS = ActiveWorkbook.Worksheets.Count
For j = 1 To WS
If Left(ActiveSheet.Name, 4) <> "OSR_" Then
For i = 1 To 1000
If Range("E" & i).Value = 0 And Range("F" & i).Value = 0 And Range("G" & i).Value = 0 And Range("H" & i).Value = 0 Then
Rows(i).EntireRow.Hidden = True
Application.ScreenUpdating = True