I have columns that are set up to automatically respond when they contain the
target cell. The code below all works fine. My problem is that when I
finished I need to clear these cells. I am currently doing this by selecting
a range and making it equal to "". This causes an error in the code below. Is
there some way of disabling the target code when I delete the range.

Thanks

If Target.Column = 11 Then
Target.Offset(0, 1) = WorksheetFunction.Max(Range("L:L")) + 1