MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Macro to hide rows based on value of 0

Posted by Angela on February 10, 2002 4:58 PM

I have a spreadsheet that has about a thousand rows of data. Some of the rows are zero and other rows have data. How can I make a macro to hide only the rows that are zero and leave the rest of the rows with data visible?

Posted by anno on February 10, 2002 5:53 PM

see 21031.html