Help with hiding certain rows whilst others remain visible based upon multiple values.

Hi, I've got a VBA scripts working well where certain rows are hidden based upon values selected from drop-down lists in specific cells.

This is as below:
Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Cells.Count > 1 Then Exit Sub
If Target.Value = "" Then Exit Sub
If Target.Address = "$C$2" Then Range("78:93").EntireRow.Hidden = Target.Value = "No"
If Target.Address = "$C$3" Then Range("16:29,31:31,37:44,45:46,48:66,72:77,94:95,97:99,101:107,120:121,127:294").EntireRow.Hidden = Target.Value = "T3/T4"
If Target.Address = "$C$4" Then Range("122:126").EntireRow.Hidden = Target.Value = "No"

End Sub

What I now need some help with is to develop this code so that if the answer to the 2nd If Target .Address question isn't "T3/T4" and is "T1/T2" instead, and the answer to another question (which I will be adding so that the answer is in C5) is "No" how can I make specific rows hidden with that combination?

Hopefully, that makes sense.

Simon.

If you're changing C5 as part of this event, then you probably need to disable events.

Please Login or Register  to view this content.