Not directly. The help on filter cites sourcearray (the first argument) as a
one dimensional array of strings.
While you could program around this to extract the filter column, use filter
to build an array of those row "indexes" that meet the criteria and so
forth, it might be just as easy to go through your array and do a simple if
test - then put each matching row in another array.
--
Regards,
Tom Ogilvy
wrote in message
...
Thankyou for this Tom
Can I get this to work on multidimensional arrays?
-----Original Message-----
Sub Tester1()
varr = Array("ABCD", "ADCE", "BCDA", "1234", "ECDA")
varr1 = Filter(varr, "BC", True, vbTextCompare)
For i = LBound(varr1) To UBound(varr1)
Debug.Print varr1(i)
Next
End Sub
--
Regards,
Tom Ogilvy
David Robinson
wrote in message
...
can someone post an example of the Filter Function in
VB.
.