Unhide rows on another sheet when cell is populated

[povictory]

Hello,

Looking for some VBA help on this issue - Have two sheets (Sheet1 and Sheet2). On Sheet1, I want to make it so that populating cell N10 will unhide rows 10-19 on Sheet2...If N10 is blank on Sheet1, then rows 10-20 on Sheet2 will be hidden. And then also on Sheet1, same situation for cell N11 - if it's populated, I want rows 20-29 on Sheet2 to be unhidden, but to be hidden in the event that N11 is blank.

Any assistance on this is greatly appreciated!

 

[kevin9999]

You've got an overlap there on row 20 in your logic - if N10 is blank then row 20 will be hidden, but if N11 is populated it will be unhidden? Assuming you want the range to be rows 10-19 inclusive, see if this gives you what you want in the worksheet coode area for sheet 1.

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Range("N10:N11"), Target) Is Nothing Then
        If Me.Range("N10") <> "" Then
            Worksheets("Sheet2").Rows("10:19").Hidden = False
        Else
            Worksheets("Sheet2").Rows("10:19").Hidden = True
        End If
        If Me.Range("N11") <> "" Then
            Worksheets("Sheet2").Rows("20:29").Hidden = False
        Else
            Worksheets("Sheet2").Rows("20:29").Hidden = True
        End If
    End If
End Sub