PDA

View Full Version : Solved: countif



chungtinhlak
01-06-2009, 09:24 AM
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
01-06-2009, 09:26 AM
SEARCH is case insensitive.

Bob Phillips
01-06-2009, 09:29 AM
BTW, COUNTIF works well into 200 for me.

chungtinhlak
01-06-2009, 10:49 AM
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