Dynamically adding or removing rows

[Mhowells]

Is it possible to get Excel to add or remove rows based on given criteria? I have a statistics table which sits just below my data, and I want to make sure that it always sits two blank rows below the last row of data.

The logic is that if a user dares to add data into one of those blank rows, the spreadsheet will automatically add another one.

Any suggestions?

Best,
Max

 

[Excelenator]

The logic is that if a user dares to add data into one of those blank rows, the spreadsheet will automatically add another one.

In that case you can use this

Private Sub Worksheet_Change(ByVal Target As Range)
    If Worksheets("Sheet1").ChartObjects(1).TopLeftCell.Row - Target.Row <= 2 Then
        Application.EnableEvents = False
        Target.Offset(1, 0).EntireRow.Insert
        Application.EnableEvents = True
    End If
End Sub