I don't know how you've actually coded this, but you need to disable events (application.enablevents=false) before doing anything (like pasting data) that will trigger the change event again, and then re-enable events when you're done.