Excel unhide rows as data is entered

Question

I am trying to write a simple code that automatically unhides the next row if data is entered on the previous row. the idea being as someone puts more details to the spreadsheet it grows as needed with all the excess rows hidden at the start.

The range is from rows 2 to 56 but row 56.

Data is entered from columns D to M but i only want column D to be evaluated when unhiding the rows

Sub UnHideRows()
Dim i As Integer
    If Target.Address = Worksheet("Blah").Range("D3:D55") Then
        i = ActiveCell.Row
        Worksheet("Blah").Row(i+1).hidden = false
    End if
End Sub

Unfortunatly this does not work and i only want it to unhide the following row if data is entered into the current rows D cell. any help would be appreciated. it doesnt need to rehide the row if all data is removed either.

Answer 1

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count = 1 And _
   Target.Offset(1, 0).EntireRow.Hidden Then
        Target.Offset(1, 0).EntireRow.Hidden = False
        ' Target.Offset(1, 0).Activate '
End If
End Sub

---

i only want column D to be evaluated when unhiding the rows

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count = 1 And _
   Target.Column = 4 And _
   Target.Offset(1, 0).EntireRow.Hidden Then
        Target.Offset(1, 0).EntireRow.Hidden = False
        ' Target.Offset(1, 0).Activate '
End If
End Sub