Macro for hiding rows

[byaniess]

Is it possible to construct a macro to hid all rows that contain "0" in a select column's cells? (All cells in column B that = 0, hide that row - NOT the column, just the row.) Hopefully this makes sense! Anyway, if this is possible, what would the macro be? I can't write (or even record) a macro to save my life. Any help would be greatly appreciated!
Thank you!!!!
Becky

 

[Joe4]

There are tons of old threads on this out there you can find using the Search functionality on this board. Here are a few:
http://www.mrexcel.com/forum/showthread.php?t=459319
http://www.mrexcel.com/forum/showthread.php?t=490899

 

[byaniess]

Hi Joe4,
Thanks, I tried the macros provided in each of the threads you found, but I don't know how to modify them for my puprose. I'm as dumb as a bag of hammers when it comes to macros. I'll keep tinkering with them, hopefully I stumble upon something. Thanks,
Becky

 

[Joe4]

Here is a quick one that I came up with works:

Sub MyHideRows()
 
    Dim i As Long
    
    Application.ScreenUpdating = False
    For i = 1 To Cells(Rows.Count, "B").End(xlUp).Row
        If Len(Cells(i, "B")) > 0 And Cells(i, "B") = 0 Then Rows(i).EntireRow.Hidden = True
    Next i
    
    Application.ScreenUpdating = True
        
End Sub

 

[byaniess]

Joe4, as I'm sure you already know, YOU'RE AWESOME! That worked! I can't thank you enough. You're my hero!
Thanks again,
Becky