Instr function with named range

Hi,

I would like to write a macro in with an InStr function referring to a named range. The InStr function searches if a part of the string occurs in the named range and if true it places a certain string in the column next to it.

I am not familiar with referring to namedranges in vba. I wrote this macro, but it doesn't work because i don't refer to the named range properly. I wrote this macro below. Any ideas how to do this?

Any input is much appreciated!

Please Login or Register  to view this content.

Thanks Rorya, your answer is much appreciated!