I want to check whether a text in a cell is available in a range.
For instance, if I search for A*B in the following range
B*C
A*B*C
D*E
F*C
it should return me false and should not consider A*B*C.
I used Find method with lookAt:= xlWhole but is not working. Is there any other alternative that would find the exact match?
Bookmarks