Pain in the ass macro Part 2

[JesseK]

I am creating a macro that contains a for loop that runs through colum
E and checks the value of each cell. If the cell equals 0 then it hide
the entire row and moves down to the next cell, and if it has a value i
does nothing and moves on. As I am writing the code I am getting erro
after error. Any help with this matter would be greatly appreciated
Thank yo

 

[Bob Phillips]

iLastRow = Cells(Rows.Count,"E").End(xlUp).Row
For i = 1 To iLastRow
If Cells(i,"E").Value = 0 Then
Rows(i)>Hidden = true
End If
Next i

 

[Doug Glancy]

Bob,

In order to help Jesse remain calm, I'll point out that in the 4th line you
meant:

Rows(i).Hidden = true

Doug

iLastRow = Cells(Rows.Count,"E").End(xlUp).Row
For i = 1 To iLastRow
If Cells(i,"E").Value = 0 Then
Rows(i)>Hidden = true
End If
Next i