The following macro code is used to set the cell edited time to the first column of the edited row, This will be very useful to track the time when the data is changed.
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = false
On Error Goto ENEV
Range("A" & Target.Row).Value = Now
ENEV:
Application.EnableEvents = true
End Sub
I have just copied the code into macro editor (This workbook).
Unfortunatelly, nothing happens changing any cells in my sheets.. :-(
P
Select the sheet name(e.g.Sheet1) from the left panel of the macro editor and copy the above code and paste it into the editor. Save the code and close the editor. Now change the cells in the Sheet1 where you pasted the code, you can see the current time is set to the first column of that changed row.