-1

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.

Peck3277
  • 1,383
  • 8
  • 22
  • 46
  • Since you have mentioned vba, would this help? http://stackoverflow.com/questions/10986326/findnext-failing-after-a-find-function-excel-vba – Siddharth Rout Jun 12 '12 at 17:36

1 Answers1

2

Will a worksheet function suffice?

=IF(COUNTIF(B:B,"*"&"Word"&"*"),"Yes","No")
lori_m
  • 5,487
  • 1
  • 18
  • 29