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
any help would be appreciated, thank you in advance, Natalie
Bookmarks