VBA Excel Macro Hide Rows Based on Cell Value

Hello,

I am looking for VBA to hide rows based on if a cell value is zero and then loop down the spreadsheet and hide all rows with the corresponding cell value as zero. I know how to do this when it is a bit more simple and less variables.

The number of lines for each account can vary on this spreadsheet. The attached sheet is a smaller spreadsheet but in reality there is about 150 accounts, so something that can easily scan through each section not showing a balance on the Trial Balance column and hiding that section of rows would be really nice through a macro and not having to manually do it. Any help is appreciated!!

Thanks!

How about

Please Login or Register  to view this content.