How to evaluate array formulae with the Evaluate method
To return an array, you need to use a function that supports an array as a result.
The function usually used with VBA to evaluate an expression to an array is INDEX since it doesn't alter the values :
Dim data()data = Evaluate("INDEX(LEN(A1:A5)>3,)")