VBA hide rows if value in cells is "0" or "(blank)"

[mistatasty]

I have a table where I need to hide the rows if the values in A24:A247 are either "0" or have the text "(blank)" in them. For some reason this code only hides rows with 0's and not the "(blank)"s. Anyone know why?

Private Sub Worksheet_Calculate()
Dim c As Range
Application.EnableEvents = False

For Each c In Range("A23:A247")
c.EntireRow.Hidden = c.Value = "(blank)"

Next

For Each c In Range("A23:A247")
c.EntireRow.Hidden = c.Value = "0"

Next

Range("A:B").EntireColumn.AutoFit
Range("D:AN").EntireColumn.AutoFit

For Each c In Range("e23:an23")
c.EntireColumn.Hidden = c.Value = "0"
Next

Application.EnableEvents = True
End Sub

 

[rollis13]

That happens because when you do the first loop when it finds a "(blank)" c.Value = "(blank)" will be TRUE so the row will become "Hidden" as required, then when you do the second loop the same row with a "(blank)" c.Value = "(blank)" this time will be FALSE so the row will once again become "Visible".
If you invert the two loops you will notice that this time the rows with "0" won't be "Hidden".

 

[mistatasty]

That happens because when you do the first loop when it finds a "(blank)" c.Value = "(blank)" will be TRUE so the row will become "Hidden" as required, then when you do the second loop the same row with a "(blank)" c.Value = "(blank)" this time will be FALSE so the row will once again become "Visible".
If you invert the two loops you will notice that this time the rows with 0 won't be "Hidden".

what do you mean invert the loops? how would that look?

 

[rollis13]

I mean 'swap' the loops: the first loop becomes second and the second becomes first in the order of the rows of the code.

 

[rollis13]

Sorry, I just noticed that in my post #2 I did a bad Copy/Paste with the test marked [Inline code], should have been:
c.Value = "(blank)" the first and:
c.Value = "0" the second.