You are right, it is deleting everything in Column A. I also noticed that but I'm OK with that.

Anyway, both of your codes helped me to do some other things that I want to implement later.

Thanks again!