C# Excel Add-in UDF which returns results multiple cells

[Francis]

Hi!

I am a beginner in writing addin. I am using C# in Visual Studio 2008. I
wish to create an addin with an user definied function where I can type in
the function in a single cell, hit enter and then the results will return in
multiple cells. I am trying to do this with a COM-automation addin.

I know I can do this by returning object[,] in my function but it requires
me to highlight multiple result cells with hitting ctrl-shift-enter. Is there
anyway to avoid this? I saw a thrid party add-in where I can type in a
function in a single cell and it expand the result into multiple cells, I
wish to do the same.

Is there a way to access the spreadsheet object from my COM-automation addin?

Thanks,
Francis