Hi,
I'm currently using the following simple code in my worksheet.
It's simply changing the status of a job if another columns status changes.
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("C:C")) Is Nothing Then
Range("B" & Target.Row).Value = Now...