Array Formula
 

Does vba have the equivalent of array formula functionality in Excel? I have
been using For Next loops in a user defined function to identify rows in a
data list that match a criterion. However, the UDFs take a lot of time to
process.

Thanks for any suggestions.
--
Tom Ulincy

Array Formula
 

Yes indeed. Formula.Array = <expression

DM

"Tom Ulincy" wrote in message
...
Does vba have the equivalent of array formula functionality in Excel? I
have
been using For Next loops in a user defined function to identify rows in a
data list that match a criterion. However, the UDFs take a lot of time to
process.

Thanks for any suggestions.
--
Tom Ulincy

Array Formula
 

Only using Evaluate as a virtual cell.

FormulaArray is for entering an array formula in a cell programatically and
would not work in a UDF used in a worksheet.

--
regards,
Tom Ogilvy

"Tom Ulincy" wrote in message
...
Does vba have the equivalent of array formula functionality in Excel? I
have
been using For Next loops in a user defined function to identify rows in a
data list that match a criterion. However, the UDFs take a lot of time to
process.

Thanks for any suggestions.
--
Tom Ulincy