Multilple selection delete issue

I have a code that works fine, if I click on a cell and click delete its fine; however if I highlight more than one cell and press delete it triggers the messagebox in the code and sends the message in a loop.

Note: in some cases it doesnt throw the messagebox, it actually gives a run time error, I am not seeing the error now but it refers to type mismatch.


Can anyone tell me what is causing that?

below is the code i am having the issue with:

Please Login or Register  to view this content.

Thank you so much it worked very well. Wow!! and to think the answer was that simple, you all bright people make people like us feel silly!

Originally Posted by p24leclerc

When you program an Events procedure like this, you have to disable EVENTS in order for the event not call itself in loop

You have to put this line of code at the beginning of your macro:

Please Login or Register  to view this content.

and you MUSt re-enable the events before the macro ends with this line of code:

Please Login or Register  to view this content.