deleting cells that are controlled using Target code

[NDBC]

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

 

[Don Guillett]

try this as the first line
If Target.Count > 1 Then Exit Sub

 

[NDBC]

Don. Works a treat. Thanks again.

try this as the first line
If Target.Count > 1 Then Exit Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)