Error 13 when searching for string matching range values

Col A of Sheet 2 has a series of "keywords"

Col B on sheet 1 has a list of products.

Macro should "cycle" through each product to find matches with any keyword.

If a match is found. the keyword should be added to Col C of the row

If no match is found, Col C of the row becomes "Other"

Code is throwing an Error 13 "Type Mismatch"

Please Login or Register  to view this content.

Suggestions and pointers welcome as ever

Ochimus

Hi Ochimus,
It's just a question of closely looking at what you're doing and avoiding syntax errors

The red code is a syntax error, you forgot the first parameter with Instr

The green is new code. This is to check if something was found. If it is false after the second loop then Other,

In your method Other will always be set

Please Login or Register  to view this content.

Hope this helps

It happens, you're so focused on one thing that the other one is forgotten.
Glad to have helped