Array Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CSE with function returning an array? 2
Array Formula In IF Function 0
UDF for Aging in excel - Help needed 15
Use of array formula 6
How can I sum two arrays together? 4
Scalar Multiplying VBA Array 8
Range reference in array formula 2
Excel VBA 1

Back
Top