returning more than one value from a VBA function

I have a function that returns multiple values. How can I return these
values to spreadsheet and how can I call this function from another
function? Is an array the best way to go? Also, can I use 2 (or more)
dimensional arrays as parameters for functions? ParamArray seems to limit
to one-dimensional arrays.

thanks