(RESOLVED) How to create a function that returns an array?

[tassosp]

Apologies if this has been covered before, I am trying to create a function that will return an array - I'm not sure how to declare this.

If this is the declaration:

Private Function NameOfFunction(blablabla) As Double

I want "NameOfFunction" to be, say, a 10*10 array. Any suggestions would be great.

Another question too, after I'm done with this, can I just assign this to an array, like:
dim table(9,9) as Double
table=NameOfFunction

... or will I need to assign each element of the array separately?

Thank you!