Auto date & Time

[monika_s]

Hi, I'm new on here and new to VBA. I am trying to set up a spreadsheet which automatically puts the current date and time into a particular column when another cell on that row is completed. I found some coding that someone had come up with but although it was working beautifully since saving the spreadsheet and closing it it now isn't working. What am I doing wrong? I have saved it as a macro enabled spreadsheet and the coding reads as follows:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Row > 1 Then Cells(Target.Row, "D") = Now()
End Sub

All help very welcome
thanks