Try this in the worksheet codePrivate Sub Worksheet_Change(ByVal Target As Range)If Intersect(Target, ActiveSheet.Range("A:A")) Is Nothing Then Exit SubRange("B" & Target.Row).Value = Now()End Sub