How do I use an array function in Visual basic .NET?

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

Guest

To enter an array function directly in a spreadsheet you use
Ctrl-Shift-Enter. Obviously, you can't do that when writing VB code. Are
array functions accessible from VB. I am trying to use an array function
using MATCH and IF to look up a row based on two parameters in different
columns.
 
Array functions can't be used in VBA. You have to pass them as you would
write them in the cell to the evaluate function. The evaluate function
would then return the result.
 
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
Use VB array as as argument for worksheet function 9
Arrays 3
Getting output from the TREND function using VBA 3
Getting #VALUE! while entering UDF as an array function 4
How can I tell the shape of a Variant containing an Array? 3
Using user function (vba) with sqrt(array)-only first answer 1
Accessing individual elements of an array returned by a function 1

Back
Top