VBA查找功能找不到给定值

I have written a program that, at one point, searches a row for a given vendor name, and then pulls that vendor's project cost from that column. The vendor name in the spreadsheet is pulled directly from a cover page, and the program reads the vendor name from that same source. This program is in 80+ separate excel files, and works beautifully in almost every single one. However, there are two or three that can't find any of the values in the given range, despite the fact that I am looking right at the value that I'm trying to search for. I tried manually using the find function in Excel, and it fails to find the string as well. What could be preventing Excel from finding these values?I have written a program that, at one point, se