You give conflicting criteria - "both cells contain zeros" and "col b or
col c is zero"

Which do you mean?

In article ,
"Macro to hide rows in spreadwsheet" <Macro to hide rows in
spreadwsheet @discussions.microsoft.com wrote:

i want a looping macro that evaluates two columns in each row of the
spreadsheet and if both cell contain zeros hide the row. Basically if col b
or col c is zero hide row otherwise don't hdie and move down one row to
evaluate it,