Conditional macro to hide rows
 

try:
with Range("your range")
for each cell in .columns(3) 'column within the range with the hours
if cell=0 then
cell.entirerow.hidden=true
else
cell.entirerow.hidden=false
end if
next
end with



"cher" wrote:

I have a worksheet containing employee ID numbers and hours worked on each
job. I need help with a macro to hide all rows on the worksheet that have
zero hours for any job.