Hiding/Unhiding Rows based on Multiple Drop Downs

[ncsps]

Hi everyone!

I currently have 5 separate drop downs in B2-B6 where possible answers are either Yes or No.
If B2 = Yes then I want rows 9-136 to be unhidden.
If B3 = Yes then rows 237-237 to be unhidden.
If B4 = Yes then rows 238-292
If B5 = Yes then rows 293-299
If B6 = Yes then rows 301-307

If the user changes their mind and says 'No' to any of these I need those rows to be hidden again.
I have tried a few formulas including the below but it doesn't seem to work. Any ideas would be much appreciated. Thank you!

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Select Case True
Case Target.Address = "$B$2"
Range("9:136").Rows.Hidden = (Target.Value = "No")
Case Target.Address = "$B$3"
Range("137:237").Rows.Hidden = (Target.Value = "No")
Case Target.Address = "$B$4"
Range("238:292").Rows.Hidden = (Target.Value = "No")
Case Target.Address = "$B$5"
Range("293:299").Rows.Hidden = (Target.Value = "No")
Case Target.Address = "$B$6"
Range("301:307").Rows.Hidden = (Target.Value = "No")
End Select

End Sub

[KOKOSEK]

Try this:

Please Login or Register  to view this content.