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