VBA Search a set of strings, return specific data if found

[banaanas]

Hi!

I have a workbook with 2 sheets.

Sheet 1 has written text in column A. Now i want to find if the text has a set of keywords that i have colected in sheet2.

If the macro finds a match, will it paste a code from sheet2 column B to sheet1 column B.

I got it almost to work with this:

Please Login or Register  to view this content.

The problem is that the macro only finds and pastes the first match in sheet1.

What i really want is to search a set range (A1-A100) in sheet1 and repleace ALL instances, not only the first one.

Here is the example:

Book1.xlsm

[nilem]

Hi
try removing this line from your code

Please Login or Register  to view this content.

[banaanas]

Oh my, thanks a bunch, that worked.

One more question, how can i define the A columns search range in sheet1?

I would like the macro only to look for values in A10-A200.