About Us

Tom Ulincy[_4_]

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

David Myle

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

Tom Ogilvy

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Array formula SUMIF with 2D sum_range array	Rich_84	Excel Worksheet Functions	3	April 3rd 09 10:46 PM
Array formula: how to join 2 ranges together to form one array?	Rich_84	Excel Worksheet Functions	2	April 1st 09 06:38 PM
Find specific value in array of array formula	DzednConfsd	Excel Worksheet Functions	2	January 13th 09 06:19 AM
meaning of : IF(Switch; Average(array A, array B); array A)	DXAT	Excel Worksheet Functions	1	October 24th 06 06:11 PM
Array Formula - using LEFT("text",4) in formula	Andrew L via OfficeKB.com	Excel Worksheet Functions	2	August 1st 05 02:36 PM

Menu

About Us