Something that's puzzeling me for some time, that I can't find in any of the books, although it's probably pretty straighforward

How can one reference to dynamic arrays in function arguments? Suppose I want to program a function like MMULT to be used in Excel (for instance DETERMINANT to calculate the determinant of a matrix), that can uses a range of values as argument (a matrix). When using function MMULT in excel you select a (variable! So dynamic array?) range of values as it's argument, and press CTRL-SHFT-Enter to return again a range of values. How can I achieve this when programming myself

- How is the function declared? Like Function Determinant(argument), what should argument be
- How can one reference to the range in the argument? How can we determine it's size (max row, max column)? How does one reference to it's elements
- When the result should be a range or matrix, how is this achieved

I'm sorry if this problem is too simple, but I cannot find anything about this in the manuals or on-line help. It's frustrating..

Thanks in advance

Rem