Hi Urchino, welcome to the forum.
I'd recommend a small adjustment:
Also note that if this is part of a change event -- or if you have a Worksheet_Change event that does something else -- you should disable events within this macro so you are not triggering that event repeatedly. You can do so by adding this before the deletions:
One final note: If your macro crashes before re-enabling events, no other macros will work in Excel. You will need to re-enable macros by running that last line of code by itself (you can put it in a small Sub/EndSub).
A better way would be to add error handling to your macro, so that if an error does occur it is trapped and you can re-enable events and other settings before the macro completely finishes running. For that, do some searching here (many examples) and Google.
Bookmarks