Hiding Rows

Posted by Mark Jones on October 05, 2001 3:21 AM

Help !!

How can I hide a row of my table if a given cells is zero. eg If column B is zero I would like to hide the entire row, if it is anything else I wish the row to be visible. Do I use a macro or a script or both ???

Any help is gratefully received

Thanks

Mark

Posted by lenze on October 05, 2001 5:25 AM

Hi Mark:
You can use a macro, but the simple way is to use the Custom feature of Auto Filter to exclude rows where column B=0.