Sharid
Well-known Member
- Joined
- Apr 22, 2007
- Messages
- 1,066
- Office Version
- 2016
- Platform
- Windows
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.
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.