Error - copy method of range class failed

[Zygoid]

I want to search range("K2:K") on sheet1 for values listed in range("A2:A") on sheet2 and if found copy/paste entirerow to next available row on sheet3

this is what I have come up with so far (with variations)

Please Login or Register  to view this content.

I am getting a "copy method of range class failed"

Thanks for any help!

[dominicb]

Good morning Zygoid

Where is the code located?
If you've put it into one of the sheet modules then you need to move it into a general module.

If this isn't the case can you tell us where it is erroring out?

HTH

DominicB