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

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

loop