Thread: Array Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
David Myle David Myle is offline
external usenet poster
 
Posts: 11
Default 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