Macro to Hide Rows with a Condition

[markf5998]

I have a worksheet where AU6:AU55 contain a number which is zero or greater.

I'd like to be able to hide rows where AU6:AU55 = 0, but only after the last time AU6:AU55 was >0.

For example, if [AU6=1, AU7=0,AU8=1] then AU9:AU55 should be hidden and AU7 should remain visible, since there was a >0 after it.

I tried to search for similar problems, but I don't know enough VB to modify code that I found to fit this condition. Thanks for any suggestions!!

 

[texasalynn]

ok so I tested that and it gives "label not defined" in VBA

 

[chuckles1066]

ok so I tested that and it gives "label not defined" in VBA

Thanks for that, I'm sure I'm using a macro somewhere with a GoTo 0 in and it definitely doesn't have a 0 as a separate line.

I will investigate.......

Although, I guess if the GoTo 0 never gets called, it's irrelevant?

 

[markf5998]

Texasalynn - Thanks for the reply...I tried your code and it hides everything after the first blank row.

Chuckles - The code without the 0 in it results in a "Compile Error: Label Not Defined"

Thanks!!

 

[texasalynn]

hmm - works with my test but I'll take a look at it. Or are you satisfied with the earlier answer?

 

[markf5998]

Earlier answer is working as needed, but if you want me to test your code for "fun" (!!) I will gladly do it!

 

[hubblenutt]

Doesn't work texas. just highlights the range. doesnt hide anything.