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.