Finding data using .Cells.Find

Back again :-)

I thought I understood the syntax of .Cells.Find, but my code is proving me wrong.

Please Login or Register  to view this content.

When I run this, it _should_:
1) clear out existing data (which it does)
2) go through a series of columns that contain data (which it does)
3) in each column, go through line by line, and see if the data appears on another sheet (which it does _not_)
4) if it finds the data, skip to the next entry. If not, copy the data over (which it does, but since it doesn't seem to find the data in the other sheet, all the data gets copied over)

Where did I go wrong?

Thanks!