deleting cells that are controlled by target code

N

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

deleting cells that are controlled using Target code 2
Deleting specific information 1
selectin the whole column beside the target cell 4
Pass condition formatting across worksheets via vba. 0
input info when pasted in cells 5
Converting URLs in comments to Markdown-formatted links 2
Change_Event not responding to change made by formula. 11
capture date at another sheets using Marlett 1

Top