Hide rows for blank Cells when there is another blank cell below

Hi,

I have spreadsheet that has VBA to hide rows based on column F being 0. The formula works perfect except for one issue. There are Headings in Column D that have Blanks in column F and they need to stay if any of the cells below the heading have a value, but be hidden if the cell below is a blank. Is there a way anyone knows how this can be accomplished? My current code is as follows, but all the blank are left in it.

Please Login or Register  to view this content.

Thank you!

I have figured out the solution in part. Here is the code after my soution:

Please Login or Register  to view this content.

The problem is with this line:

Please Login or Register  to view this content.

I have data as follows:

Description (With blank in Column F)
Data (With value in Column F, Will be 0 or Positive number)

If the Description has only data underneath that is 0 I want the Description to hide, but with the code I have written it will hide the description if the the cell below is 0 and say 3 columns down there is data. That leaves the data without a Description. I want the Description to only be removed if there is not data under the Description. My thought was (not sure if this is how VBA works, still fairly new) if the first part of my code hides the data that need to be hidden, then the next part of my would only hide the header if the visible cell below is a blank. Is there a way to make that happen?

I hope I was clear in my description, but if I am not clear please let me know and I will try and explain it better.




Thanks!

Hi,

I was given the following code that solved my problem from a someone, but they did not have time to explain it for me. It is functional for what I want, but I was wondering if someone could help explain what is going on in the code so I can better understand it and in the future write my own code for similar circumstances. Any help is greatly appreciated.

Please Login or Register  to view this content.

Thank you!