Can you post 2 workbooks so we can verify the code.
If the purpose is to check for occurence in targetfile VBA has built-in functions to search for a value so you don't need to use worksheetfunctions.