Macro to hide rows READ ME please
Posted by ark on February 12, 2002 1:54 PM
Hello,
I need a formula or a macro that programmatically hide (or better move up) all the rows THAT DOES NOT CONTAIN DATA OR THAT CONTAIN A CERTAIN VALUE, i.e. #rif, zero, or #value.
Thank you all
Posted by Paul B on February 12, 2002 6:56 PM
Have a look at http://www.asaputilities.com/ it is a addin for excel under columns/rows it has a function called conditional row and column select, hide or delete, I think this will do what you want to do
