Using Find and Returning the Column Number of the Found Cell

Hello,

I am trying to lookup a text string in a row and return the column number of that string. Here is my code:

Please Login or Register  to view this content.

Frustratingly, it sometimes works, but other times does not. I am assuming my code is not sound. Any help is greatly appreciated. Thanks.

Steve

Hi,

Try

Please Login or Register  to view this content.

Charles,

Your code works wonderfully. Do you think my issue was trying to define to many components of the Find function?

PS: I don't know if you remember, but you helped me out immensely about a year ago. Many thanks!

Yes,

I remember you. All ways happy to help all.
As for your code you need to see if the Item was found. Hence

Please Login or Register  to view this content.

If the item was not found then the code will end.

Robotacha2010,

Glade it helped you. And thanks for the rep from you and Steve.

Makes sense. Way to kill 2 birds with one stone, btw!

No need to thank for the rep, it was well deserved.