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

Pls do NOT post in more than one group.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"NDBC" <(E-Mail Removed)> wrote in message
news:3E45DFCC-9B84-47E6-8F00-(E-Mail Removed)...
>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
>