I am trying to set up a macro that will identify if a field has been changed. I need the syntax for how to get this done. Below is the original Macro. I want to see if someone changes a field from the default below. Can someone help?
Thanks in advance,


Sub CEO_OC()
Dim LR As Long
Dim i As Long
LR = Range("D" & Rows.Count).End(xlUp).Row
For i = 2 To LR
If Range("D" & i).Value = "Facility CEO" Then
Range("f" & i).Value = ""
Range("j" & i).Value = "X"
Range("n" & i).Value = ""
Range("r" & i).Value = ""
Range("v" & i).Value = "X"
Range("z" & i).Value = ""
Range("ad" & i).Value = "X"
Range("ah" & i).Value = ""
Range("al" & i).Value = "X"
Range("ap" & i).Value = ""
Range("at" & i).Value = ""
Range("ax" & i).Value = "X"
Range("bb" & i).Value = ""
Range("bf" & i).Value = ""
Range("bj" & i).Value = ""
Range("bn" & i).Value = "X"
Range("br" & i).Value = ""
Range("bu" & i).Value = ""
Range("bz" & i).Value = ""
Range("cd" & i).Value = ""
Range("ch" & i).Value = ""
Range("cl" & i).Value = ""
Range("cp" & i).Value = "X"

End If
Next i
End Sub