Multiple Macros to hide rows dependent on Yes/No answer on the same sheet

Hi All,

First of all thanks for all of the help posted on this forum, normally i can find the answer to my questions without having to post.

I have a situation where i am using a macro to hide rows dependent on a yes/no answer from a list via validation.

The formula i found on here is as below and works great:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("G7")) Is Nothing Then
        If Range("G7").Value = "No" Then
            Rows("94:102").Hidden = True
        Else
            Rows("94:102").Hidden = False
        End If
End If
End Sub

I now need to run the same macro but for several other yes/no cells e.g. G6,G8 and G9 and if they are also "no" responses i need it to hide different rows. I think there will be 6/7 of these formulas in the end.

I thought i could simply copy the marco again after the first macro but that doesnt seem to work, i am sure i have missed something really obvious here, but would welcome anybodys advice on how to correct this issue.

Many thanks in advance for your help.