Tuesday, March 18, 2014

Excel VBA – How to Find if an Array Contains a String

Function IsInArray(stringToBeFound As String, arr As Variant) As Boolean IsInArray = (UBound(Filter(arr, stringToBeFound)) > -1) End Function

No comments:

Post a Comment