Macro to Hide the whole row if formulas in column L are returning zeros

[mirving]

Hi,

Could someone help me out with a macro to hide all rows that have either blanks or zeros returning in column L. I have a very long report (about 300 rows) that has values returning in column L. Many of these rows have zeros or blanks each month and make the report very unfriendly to read. I have to hide these rows manually and it takes a long time. I would like to consolidate the report by hiding the rows, make it easier to read, and save some time using a macro.

Thanks

[Kaper]

set of 2 simple ones:

Please Login or Register  to view this content.

PS. You can achieve similar result without macro - just by filtering

[JOHN H. DAVIS]

Another:

Please Login or Register  to view this content.

[mirving]

Thank you very much! It works like a charm!