Find Just Doesn't Work....

[cicconmr]

Does any one else have this problem where your find routine works some times but not others....even when you test it by searching for the same thing? Is this a common error...I could not find anything on it.

This sheet is for other people to use and it really is sad when I get emails that the find doesn't work all the time.....

 

[RoryA]

Find remembers all its settings between uses, including uses in the UI rather than code. It is therefore recommended to always specify all the arguments for the find (such as Lookin, Lookat, matchcase) rather than assuming they will be what you want.

 

[cicconmr]

I'm Using:

Set Found = ws.Cells.Find(What:=Symbol & " ", After:=ActiveCell, LookIn:=xlValues, LookAt:= _
                xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _
                False, SearchFormat:=False)

So it is pretty detailed, here is my problem:

I want to find, say T, using LookAt:= xlWhole

This is because some tickers for stocks have T's in them, but aren't ATT the company I want. However....even though I'm sitting here looking at letter T it skips to my Error Sub.

Any ideas why this cold be? xlPart works but it also touches all cells with the letter T in them (I've tried screwing around with spaces but that doesn't help either)

 

[jmthompson]

pesky leading or trailing spaces?

 

[cicconmr]

pesky leading or trailing spaces?

Neither...it just simply does not work....it blows my mind I wish you were sitting here watching me star at the cell I want to find and have the Macro no be able to find it haha

 

[cicconmr]

Now it's working again?

Is this possible?

 

[jmthompson]

How do you determine the value for Symbol? InputBox?

 

[jmthompson]

Wait, is your Find criteria adding a trailing space?

What:=Symbol & " "

 

[RoryA]

You can't find ATT by searching for T and specifying xlWhole though.

 

[cicconmr]

Forget the & " "

Any how, I know that is how xlWhole is supposed to work @roya but it wasn't working so I was using xlPart which was kind of like a duct tape fix job.

I'll keep you posted on my progress, I'm trying to fix it so xlWhole consistantly works. I think it may have something to do with where I am searching.