unhide or hide rows depending on previous row value

good morning everyone.

can anyone help with this query?

I have a range in rows 4 to 13 in a spreadsheet.

Column B in this range can either be blank or have a value selected from a validation list.

What i would really like to do is, if B4 is left blank then rows 5 to 13 are hidden, if B4 is given a value from the validation list, then row 5 unhides, if B5 is completed then row 6 unhides etc.

Hope that is possible.
thanks

Lucy

Try this

In the worksheet module (Right click Tab .> view code)

Paste

Please Login or Register  to view this content.

thanks Marcol, that works for cell B4, and hides the rest of the section.
if i then decide that B5 is to be blank, then how do i get rows 6 to 15 to be hidden ?
I tried adapting the code like this, but it gets into a loop (i think) and everything remains unhidden.
Thanks for your help.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range("B4") = "" Then
Rows("5:15").Hidden = True
If Range("B5") = "" Then
Rows("6:15").Hidden = True
If Range("B6") = "" Then
Rows("7:15").Hidden = True
If Range("B7") = "" Then
Rows("8:15").Hidden = True
If Range("B8") = "" Then
Rows("9:15").Hidden = True
If Range("B9") = "" Then
Rows("10:15").Hidden = True
If Range("B10") = "" Then
Rows("11:15").Hidden = True
If Range("B11") = "" Then
Rows("12:15").Hidden = True
If Range("B12") = "" Then
Rows("13:15").Hidden = True
Else
Rows("5:15").Hidden = False
End If
End If
End If
End If
End If
End If
End If
End If
End If
End Sub

Hi Marcol, yes there may be instances when someone would leave a blank somewhere in the range with values above and below it.

Thanks

Lucy

Hi.
In your active sheet, try this code:

Please Login or Register  to view this content.

Thanks Wamp, that is very useful.

Best wishes
Lucy

Sorry a bit late

Try this

Please Login or Register  to view this content.

This should allow multiple deletion, and fill_down in column B

Cheers

thanks Marcol, i really appreciate you taking the time to work it out and post on the forum.

Lucy

Always happy to help.

If you need any further information, please feel free to ask further

However

If this takes care of your needs, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody!
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.