VBA to hide rows based on different cells with different criteria

[Natstin]

Hi Everyone,
I am trying to hide entire rows based on whether there is a certain criteria in certain ranges (different criteria for different ranges, if that makes sense?)

For example, I want to hide entire row IF Ranges L9:L10, L31:L33, L53:L56 = “H”
and I also need to hide the rows IF Ranges B11:B30, B34:B52, B57:B60 = “Write Text Here”

I have tried all sorts of things (albeit quite blindly as my understanding of vba is pretty basic). The code I am at now is the following and isn't working for me

Please Login or Register  to view this content.

any help would be appreciated, thank you in advance, Natalie

[LordLoki]

You were pretty close already
When you select multiple ranges in the Range you have to put everything together in quotation marks not each range seperately
And if you use the With activesheet you have to put a . in front of the range so that vba knows this range is refering to the activesheet.

Please Login or Register  to view this content.

[Natstin]

Sorry if this reply comes up twice, I replied and now I can't see that it posted

that code now runs thanks LordLoki, however it will hide all the rows for the specified L ranges but only for B11:B30 range and not for anything else beyond that, so I have a bunch of rows that say "Write text here"?

Is there something else I am missing at all?

[LordLoki]

Check if the cells really have the same Text than in your code (check for blanks etc).
Also note its Case sensitive so if you want it to not care about the case try this

Please Login or Register  to view this content.

[Natstin]

You did it, thank you so much (I had spent so much time trying to figure this out and you were exactly right, I hadn't thought about the case sensitivity of it at all)

Hugely appreciated, thank you again

[LordLoki]

Happy that i could help