Hide non-contiguous rows based on Yes/No dropdown

[gtirrell]

To preface, I have searched the forum for an answer to my question since this must be pretty basic, but have been unable to make it work.

I need a VBA code which only needs to work on 1 specific sheet. Based on a dropdown answer in cell F1 (Yes or No), I need to hide a number of non-contiguous rows. Here, "Yes" would hide the rows and "No" would unhide. The rows (right now) are 8, 29, 30, 31, and 83.

Thank you in advance!

 

[mumps]

Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. Make a selection in F1.

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.CountLarge > 1 Then Exit Sub
    If Target.Address(0, 0) <> "F1" Then Exit Sub
    Select Case Target.Value
        Case "Yes"
            Range("8:8, 29:29, 30:30, 31:31, 83:83").EntireRow.Hidden = False
        Case "No"
            Range("8:8, 29:29, 30:30, 31:31, 83:83").EntireRow.Hidden = True
    End Select
End Sub

 

[gtirrell]

Perfect, I was relatively close but clearly missing some key code. Thank you!

 

[mumps]

You are very welcome.