Ok I will try "If Not Application.Intersect(Target, Me.Columns("L:L")) Is Nothing Then" instead of "If Not Application.Intersect(Target, ActiveSheet.Columns("L:L")) Is Nothing Then", since this code is in a worksheet code module, what's exactly the difference between ActiveSheet, Me or even no additive like p45 cal proposed?