Hi,
I've write the code to be like this:
If Not Intersect(target, Range("B9", "B18", "B20", "B26", "B30", "B32")) Is Nothing Then
If target.Value = "Anytime Knock-In" & "BUY" Then
If Len(target.Value) > 2 Then Worksheets("TERMSHEET").Range("A51").Value = Worksheets("PRODUCT").Range("A38").Value
If Len(target.Value) > 2 Then Worksheets("TERMSHEET").Range("B51").Value = Worksheets("PRODUCT").Range("B38").Value
If Len(target.Value) > 2 Then Worksheets("TERMSHEET").Range("A53").Value = Worksheets("PRODUCT").Range("C9").Value
If Len(target.Value) > 2 Then Worksheets("TERMSHEET").Range("B53").Value = Worksheets("PRODUCT").Range("D9").Value
If Len(target.Value) > 2 Then Worksheets("TERMSHEET").Range("A55").Value = "Anytime Knock-In Event:"
If Len(target.Value) > 2 Then Worksheets("TERMSHEET").Range("B55").Value = "An Anytime Knock-In event is deemed to have occured when the Reference Currency Rate is deemed to have"
If Len(target.Value) > 2 Then Worksheets("TERMSHEET").Range("B56").Value = "traded to at or below the Anytime Knock-In Rate"
End If
and I got compile error. I bet there is something wrong with the colored code.