I have been stuck on this for hours now, and .find seemed to be working for me in earlier versions of the same program. I'm not sure what version of excel the file was saved as earlier when range.find was working (either 2010 or 2003), but it is now not working in Excel 2010. In order to eliminate other parts of my code as the source of the error, I literally copied and pasted the following from MSDN into my editor, put it in its own subroutine, declared the variables, and still got the same "Application-defined or object-defined error" when the code was run. Here is the code that produced the error on line , I have noted where I deviated from what was on I have been stuck on this for hours now, and .f