Hello. Here's the situation. I've written some code to help analysis a bunch of data and make my life much easier. The computer I was working on died, so I've moved to another one that's running an older version of Excel, 2000 instead of 2002. (This might come in handy later...)

I've written a function called FindCol. You feed it a search string and it'll find the row and column where there is a match. Simple. But for some reason it doesn't work in Excel 2000. When I force Excel to calculate all the cells, it returns nothing.

Upon debugging, I've discovered that the following statement,

Set found = Worksheets("3.2 Passive Assets").Range("A:Z").Find(What:="links", LookIn:=xlValues)
never finds the string. In the Immediate Window, "? found is nothing" always evaluates to true. Now, here's the twist (at least for me.) If I reset the code, and type the aforementioned find statement into the immediate window and then type "? found is nothing" it returns false.

So... when the code is executing, it can't find my string. When the code isn't running and I manual execute the find statement, it's found.

What am I doing wrong?