Code issue which I can't fix

[Sharid]

Please can someone help, I have this code which pretty much does what i want, only problem is that it stops at row 414 every time for some reason.

I have attached a downloadable excel sheet, see link below. i have removed all the emails from it.

on sheet 1 there are about 3000+ url and one command button. on sheet 2 there are about 1500+ url, but for some reason it only processes 414 urls, NOT SURE WHY?


https://app.box.com/s/vadgugwzloyuo5qwa3hmsbbikw88bwf6

The code matches the url from sheet 1 and 2 and copies the matched urls over, from sheet2 to sheet 1 column c, in column d sheet 1 it places the emails which i have removed.

it only check column A it does not check for Matches in column B sheet 2, which fine.

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1089658-match-urls-copy-paste-one-sheet-another.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).