Inserting a blank row at each change in the cell value

Hi,
Is there any easy way to insert a blank row in excel after any change in value of the previous cell? Thanks

Not sure why you want to do that. Try this:

Code:

---

Private Sub Worksheet_Change(ByVal Target As Range)
    Application.EnableEvents = False
    Me.Rows(Target.Row + 1).Insert
    Application.EnableEvents = True
End Sub

---