Hi, I have a list of medical complaints which I'm searching for in phrases using
But I need to find whole words so for example if the phrase contains "heartburn" I don't want to find "burn". How do I ensure that LookAt:=xlPart only returns whole words?
Thanks for any help
Code:
rngSearch.Find(What:=medicalComplaint, LookIn:=xlValues, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False, SearchFormat:=False)
Thanks for any help