I'm trying to build a code where the depending on the user input, it would hide certain rows. As an example, if the user selected "Yes", it would display certain rows and hide other rows. And the same when a user selects the answer "No". I was successfully able to create a this code. However, I have a similar situation, but there are two variables with the answer "yes" and "No". This would create 4 possible outcomes. I'm running into the issue that the code will not execute when the variables in B6 and B7 are modified.

I've included my line codes below. Could someone provide me with some advice as to how I can fix this?

```
Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = "B6:B7" Then
        If Range("B6").Value = "Yes" And Range("B7").Value = "Yes" Then
            Rows("12:38").EntireRow.Hidden = False
            Rows("39:57").EntireRow.Hidden = True
        ElseIf Range("B6").Value = "No" And Range("B7").Value = "Yes" Then
            Rows("12:38").EntireRow.Hidden = True
            Rows("39:57").EntireRow.Hidden = False
        ElseIf Range("B6").Value = "Yes" And Range("B7").Value = "No" Then
            Rows("12:38").EntireRow.Hidden = True
            Rows("39:57").EntireRow.Hidden = False
        ElseIf Range("B6").Value = "No" And Range("B7").Value = "No" Then
            Rows("11:38").EntireRow.Hidden = True
            Rows("39:57").EntireRow.Hidden = False
        End If
    End If
End Sub

```