Suppose I have a list of words (a rather large list of words ~55k) and I want to find the number of cells in a given range (a very large range) that contains at least one instance of that word. Is there a faster way than looping through every cell in the range and using the INSTR() function?
Code:
For i = LBOUND(words) to UBOUND(words) ' where words() contains my 55k words
wordToSearch = words(i)
For x = 1 to lastRowofRange
If INSTR(1,CSTR(Range("A" & x).Value,wordToSearch) > 0 then count = count+1
Next x
Next i