I'm creating an Excel add-in with functions to access a database. I'v
got no problem returning one value, but I don't know how to return
resultset containing more than one instance like an array.

Example:

User calls: =Analysis("12/04/2004")

And Excels returns (to the cell which the function was called) all th
the analysis on the date based on mye resultset like this:

12,4
11,2
10,1

My main problem is returning several values and displaying them.

I've seen some examples using transpose, but I'm not sure how to us
it.

Many thanks in Advance

--
Message posted from http://www.ExcelForum.com