Match column from sheet 2 to sheet 1 and copy rows if match exists.

I posted this question a few weeks ago and have since made quite a bit of progress, but I'm still lacking in one area. I'll show you my code and then tell you what I'm having a problem with. Perhaps you can help:

Please Login or Register  to view this content.

What's happening is on the time it does not find a value after a value is found, it is copying the row previously found into the row in which Brow is found.

So Arow(1) goes to Brow(1)
Arow(2) goes to Brow(2)
Arow(2) goes to Brow (3)
etc.

Instead of giving me the message that no match is found. I'm not sure where to go from here. Any ideas?

Solved:

Please Login or Register  to view this content.

Needed to tell it to return if the value proves nothing.