Require help with VBA code for hiding rows based on cells in range of columns being 0

[MonicaP]

Require help with VBA code for hiding rows based on cells in range of columns being 0
I'm found this code to use but when I use it, it hides all the rows. I need it to hide row if all cells in columns H through L show a 0 value. Can someone please help me with this.

Sub Hide_rows()

Dim LastRow As Long

Dim Rng As Range

LastRow = Range("A125").End(xlUp).Row '

Set Rng = Range("H3:L125")

Application.ScreenUpdating = False

For Each cell In Rng

If cell.Value = "0" Then

cell.EntireRow.Hidden = True

End If

Next cell

Application.ScreenUpdating = True

End Sub

 

[MonicaP]

You are welcome.
Glad I was able to help!


You can see why I asked it now. That little detail can mean the difference between working and not working.
It is never a bad idea to post a small sample of your data so we can see that, or other little things that may be important.
Many times, the devil is in the details!

I see that. Thanks again, you are a life saver!

 

[Joe4]

No worries!
Happy Excel-ling!