If there is no match, does it meant that as the code loops the msgbox appear for each unmatched row?
I do not know how you want the msgbox to appear.