MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Hiding Rows

Posted by Jeremy on August 15, 2000 2:13 PM

How do I hide rows where the value in every column has the value zero? Thanks in advance.

Posted by MIke K on August 16, 0100 5:44 AM

do until activecell.value <> 0
if activecell.value = 0 then
activecell.offset (0,1).select
else exit sub
end if