It worked perfect for first sample files I provided.
Please forgive me for providing new sample files as it seems the only solution for now.
In my current sample file there are all the elements (or say possible problems).
For my current file till raw 4 your code works fine after that when it comes to raw 5 it shows error. I thought error is because US RE44048 is not present in the database 1 file.
I don't know what the problem is but it shows
I got temporary solution.
I recorded macro to remove US [0-9]{5} and US [0-9]{8,11} in a temporary
It works fine for now. I Replaced column 3 then with original document.
Code:
Run-time Error '91':
Object Variable or with block variable not set.
I tried to add RE44048 in database1 file (last raw) still problem persist. It stopped without showing any error.
I don't have any clue whats going on now.
Please find my files at:
https://sites.google.com/site/rtsk2015/fo
Download:
Main.docx
Download:
Database1.xlsx