title: Search range of strings for a word
body: <p>I'm trying to write a function in VBA for excel. =findval("Word",B:B), I want to search the Range B:B(these are short strings) for a word. If the word exists return Yes or No. So far I can search a string for a word but I can't get this to work over a range.</p>