Can't detect Substring with InStrng function

[MaartenRo]

Hi,

I wrote a macro to check wheter cells in a column ("K:K") contain a certain substring. The problem is that my function doesn't detect the substring ("achtern").
What am i doing wrong?

Please Login or Register  to view this content.

[jindon]

Not sure what you are trying to do though, it should be

Please Login or Register  to view this content.

I don't understand about the rest...