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
Is there a way I can do this with VBA. I want to know if a cell contains a certain keyword.
Thanks