I have a drop down box (data validation list) in cell E8 and want to run an
edit on the D8 (offset 1 column) if E8 equals "flat" I cannot figure out why
my change event won't fire... How do I set up a change event around this
code and where should the code be located? THANKS!

If Target.Value = "flat" Then
ActiveCell.Offset(0, 1) = "No Discount Margin"
End If