Most often there will be a neccesity to filter content from the Array. Filter Function comes as a blessing:
Dim arOriginal(0 To 4) As String
Dim arFiltered() As String
arOriginal(0) = "Bob Woolmer"
arOriginal(1) = "Dean Jones"
arOriginal(2) = "Bob Richards"
arOriginal(3) = "Ravi Shastri"
arOriginal(4) = "Greg Chappel"
' Filtered Array will contain strings that contains Bob in it
arFiltered = Filter(arOriginal, "Bob")
' Filter - Returns a zero-based array containing subset of a string array based on a specified filter criteria.
If no matches of Bob are found within arOriginal, Filter returns an empty array. An error occurs if arOriginal is Null or is not a one-dimensional array.
The array returned by the Filter function contains only enough elements to contain the number of matched items.