Hidden cell visible using VBA?

[jackfox68]

I would like to have a range of cells A1:d10 that are hidden by default except for the first row. If the first row is populated with data then the row below that will be visible, and this would continue until all cells are filled. There would never be a situation at this point in time where more than 10 would be required.

Any suggestions?

Thanks
Brian

 

[machopicho]

Try:

Private Sub Worksheet_Change(ByVal Target As Range)
For Each cll In Range("A1:D10")
If cll <> "" Then
Rows(ActiveCell.Row + 1).EntireRow.Hidden = False
End If
Next
End Sub

This code works if activecell is on the same row after the filling cell.

 

[jackfox68]

This is great ... thank you ! I think I was trying to make it more complex than it actually was. I am still very green to VBA.