LucasSeveryn
Reputation: 6272
To check if a string contains an element from a list (of strings)
Is there any way to do that in VBA other than manually looping through the array and testing each element separately?
Upvotes: 0
Views: 2181
Answers (1)
Preston
Reputation: 8187
Check out A.S.H's answer below, Application.Match is the way to go. This will throw Error 2042 if the element is not in the array.
Answer mentioned: Checking if Value is Present in an Array
MSDN: https://msdn.microsoft.com/en-us/library/bb239415(v=office.12).aspx
Upvotes: 1
Related Questions
- Match if string contains another
- Check if a string contains another string
- Check whether a cell contains a substring from a list Excel
- If String contain a certain substring
- How do I check if cell contents match a specific string?
- Which cells from a list are in a string?
- VBA - Check If String Sentence Contains ANY Word From List
- Excel VBA. Compare if all letters in a string is in another string
- Excel: Matching a string from a list of strings
- Finding if a string contains members of a list of strings