Hiding rows based on value in cell

[Mable]

Hi, I wonder if someone could help me please?

I need to hide 8 rows (30-37) based on a value in cell B28.

If the value is 2 then only show rows 30 and 31
If the value is 3 then only show rows 30, 31 and 32
Then continue this up to the user puts in the value of 8 and no rows are hidden.

Thanks for your help with this, it is much appreciated

 

[Mable]

Thanks again, The only reason why it didnt work was that the cell reference was changed to a text name so when the code was looking for B28 it could not find it due to the cell reference been changed to text.

Again Thanks for all your help!

 

[GTO]

Okay, this one time - we'll forgive you. Totally kidding of course Glad its working for you and hope the "overwhelming" response didn't scare ya none too much! Personally I started laughing, as sometimes someone will get nary a response and will have to "bump", then the occassional "oh dear! the lights just dimmed when I checked for responses...!" happens.

You have a terrific day,

Mark