Hiding / Revealing rows based on Cell Value

[Sky188]

I'm trying to find a way to hide rows based on a rows value, and have it update when a sheet is activated.

For example, if cell O8 on sheet 1 = 1, unhide rows 29-32 on sheet 2. If O8 = 2, unhide rows 29-36.

I'm currently trying the below code, and it isn't working.

Please Login or Register  to view this content.

Any suggestions?

[xladept]

Hi Sky188,

If you're running it from sheet2 then maybe you could just get rid of the Me. (The ME Dot)

[mrice]

This seems to work when on the VBA tab for the sheet with the hidden rows

Please Login or Register  to view this content.

I'm assuming that the sheet is not protected in any way.

[RHCPgergo]

Hi,

the entirerow.hidden property is either true or false, so it can't equal something else. That's why your code doesn't work. Try something like this:

Please Login or Register  to view this content.

Edit: oooooh now that I see others post I'm getting it. Cool!

[Sky188]

Thanks for the replies everyone!
RHCPgergo, your solution worked perfectly!

[RHCPgergo]

"Below is the code I'm currently using; anytime there is a value in O8, it reveals rows 29:52, regardless of what value is in O8."

It's because of this line:

Please Login or Register  to view this content.

edit: if cell O8 is not empty, the above line translates to

Please Login or Register  to view this content.

edit2: oh, we edited at the same time. Glad it worked out in the end.