'Find' not working as expected (Excel vba).

Hi,

I have a routine that should look down a range of several columns of around 10K rows each for 'SearchItem'.
It needs to be columns because the first column is most likely to contain the item being looked for.

Here's the code.

Please Login or Register  to view this content.

I've obviously done something wrong, because here's what happened.

It worked exactly as hoped. Once. And then it never worked again. After that first time it just kept finding cell F3,

which is part of the range, but has always been empty. Since it did work once, I assume that the reason it doesn't now is something to do with the settings for After, LookIn, LookAt, etc.

I really need this to work, and if anyone can put me right I'd be deeply grateful.

'if you are searching for the same string of text every time'

Dammit. I hadn't noticed that. The code is doing the right thing, but the wrong variable name was there, and I didn't notice.

Sorry people, false alarm. On the bright side, at least it means I did get the code correct (almost).

Again, sorry about that.

And thank you 111steps for that code. It will come in handy.