Find in VBA

[Fellhouse]

Hello all,

I am pretty new to VBA, but I am trying to resolve a little issue I am having. I have a web query pulling in and then I want to search the data for several terms and then copy the relative cell to the left as a variable in my code.

I have tried to use the find method, but I am having a problem with it finding the term within another cell, but not the one I want. EX. Search term: Price: Finds: List Price: I want: Price: How can I teach it to look for cells with and only with the search term in the cell?

In addition, I have about 20 terms I am looking for, If it can't find the exact term and nothing else, how do I teach it to do the next?

Thanks a ton!

Fellhouse

[Mordred]

Hi FellHouse and welcome to the forum. Give the following code a try

Please Login or Register  to view this content.

[snb]

or

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.