Would setting Application.EnableEvents = False at the beginning and
setting it back to True at the end solve the loop issue? So would you
put the "If Target.Column = 9 Or Target.Column = 10 Then" above the
"If Range("I" & row).value = "BigSupplier" Then" line? I'll fix the
stylistic error, as well as the highlight error, change  it from
FormulaR1C1 to value and figure out how to limit the msgbox thanks!
(and then hopefully it will work >.> because on my screen it still
does nothing).