Macro works on single cell paste but not on multiple cell paste

Hey Forum,

The macro below works as intended when I either enter a new entry manually, or paste it in one by one. The problem occurs when we paste in multiple entries at once. I believe I have the problem narrowed down to this line. I am at a loss as to how to get it to work for multiple entries at once.

Please Login or Register  to view this content.

This is my macro

Please Login or Register  to view this content.

Thanks!