![]()
Private Sub Worksheet_Change(ByVal Target As Range) Dim cell As Range If Intersect(Target, Range("D:D")) Is Nothing Then Exit Sub Application.EnableEvents = False For Each cell In Intersect(Target, Range("D:D")) cell.Offset(0, 1).Value = "RECHECK STATUS" Next 'cell Application.EnableEvents = True End Sub
Regards,TMS
Bookmarks