Range timestamp

[regevli]

Hello all,

Any idea how to create a timestamp for a changed range ?
To be more specific

for each row on column 11 i want an automatic date/time of the last change made in columns 1 to 10 (in that certain row)

Thanks
Lior

 

[MrKowz]

Try out a Worksheet_Change macro. To use this, right click on the tab of the worksheet you want to run it on, and click "View Code". Paste this code in the window that pops up.

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A:J")) Is Nothing Then
    Range("K" & Target.row).Value = Now
End If
End Sub

 

[regevli]

thanks

that worked just fine