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

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Ted" wrote in message
...
I want the macro to go thru the hole worksheet row by row.
If the cell e3,e4 and so on are zero the row should be hidden.

"Bob Phillips" skrev:

Any cell?

Rows(5).Hidden = Application.Countif(Rows(5),0) 0

or a specific cell?

Rows(5).Hidden = Range("M5") .value = 0

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Ted" wrote in message
...
Hi!
I want to make a macro that hides the hole row if a cell in that row
has
the
value 0 (zero).
Dont know how to do that.
Can anyone help me with a tip how to accomplish this.
:)