Solved: countif

[chungtinhlak]

Hello, to go down each cell in the column to find particular keywords inside the cell. I use countif(range,"*keyword*") before but I notice that countif will only count about 100 characters into the text, whatever after that, it doesn't count anymore. I also looked into find function but the find function is case sentitive.

Is there a way I can do this with VBA. I want to know if a cell contains a certain keyword.

Thanks

[Bob Phillips]

SEARCH is case insensitive.

[Bob Phillips]

BTW, COUNTIF works well into 200 for me.

[chungtinhlak]

thank you, search will work. I dont know the exact character that countif do, but if i have a paragraph, it won't work.

thanks xld