Hide/Unhide lies with 0 based on 3 columns - looking to exclude from running on headers

Hi Everyone ! great to meet you. I am relatively new to Macros, I am hoping someone can help me with a macro I am trying to run.

I have attached my template to this thread and would really appreicate any tips, I am hoping it is relatively straight forward....


I have set up the Macro currently to hide all of the rows within the worksheet where there are zero between columns E9-G.

The Macro is working and is filtering out all of the 0 rows. However, I have rows which are there as they provide a header and these are being hidden as they do not contain value, I would like to stop these rows from hiding when I use the macro.

The only complications is that there are instances where I do not wish for the headers to show and that is if everything underneath is 0.

I basically want to keep the headers for where there is a catergory underneath the header which contains a value.

I hope I am making sense with what I am trying to explain and really appreciate any support.


Thanks

The Macro is working and is filtering out all of the 0 rows

It's not working for me because the blank cells don't contain zeros and Header sometimes has a : after it.

You could try it like this:

Please Login or Register  to view this content.