Function that return arrays...

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

Guest

I don't know if my question is correct...is there anyone there who knows how
to implement a function that returns multiple (multidimensional)
values...which you can reference like an array...for example...

MyFunction(1,1)=FirstComputedValue
MyFunction(1,2)=SecondComputedValue

....suggestions for an alternative method will be very much appreciated...
 
yes, function can return an array, but better to assign a local array to
function result, and then use it values. Else your function will run each
time
 
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

how pass array to a function? 14
Can I use a UDF in an array formula? 2
Question about declaring "Array" return type in VBA function 2
convert Excel VBA function to Access VBA? 14
Function Returns Multidim Array 3
MultiDimensional Array Syntax 4
How to output an array in Excel with a user-defined function? 2
Custom Function to return array 2

Back
Top