how to use result of UDF created using automation add-ins in multi

[parmanand]

problem statement:
i have created a UDF say ReturnArray(...).
I opened a new excel and included the NamespaceName.ClassName as
automation server under (Tool->Add-in->Automation->NamespaceName.ClassName)
From ReturnArray UDF I want to return suppose 5 numbers (1,2,3,4,5).
I called the UDF from cell(a1).
and i want to get the output as
in a1=1
a2=2
a3=3
a4=4
a5=5.

is this possible ?
plzzz hep me out...
its very important.

 

[XL-Dennis]

Hi,

I assume that You will create an automation add-in which work with Excel
2002 and onforward. With which tools will You develop the UDF?

Creating an UDF that output an array require that the function needs to be
array entered in order to cover a range of A1:A5. You need to include in the
UDF the ability to both work with columns and rows.

---------------
With kind regards,
Dennis
Weekly Blog .NET & Excel: http://xldennis.wordpress.com/
My English site: http://www.excelkb.com/default.aspx
My Swedish site: http://www.xldennis.com/

 

[parmanand]

hey Dennis
thanks alot.
i am not using vsto 2005.
I have simply created a class which finally work as a XLL.
Could u plzz help by giving an example...
i am little bit new to UDF and excel.

 

[XL-Dennis]

Hi,

Check out the following example (the link may be splitted on several lines
so you need to cut & paste to get the whole URL.)

http://groups.google.com/group/micr...c9b0?lnk=st&q=&rnum=15&hl=sv#8682337f6d82c9b0

---------------
With kind regards,
Dennis
Weekly Blog .NET & Excel: http://xldennis.wordpress.com/
My English site: http://www.excelkb.com/default.aspx
My Swedish site: http://www.xldennis.com/

 

[parmanand]

Hey Dennis
Thanks for helping ...
The code given by u work good in vba.
i have tried the approach given in the fillowing blog to create add-in
http://blogs.msdn.com/eric_carter/archive/2004/12/01/273127.aspx
Now i have added one more function say
FillMultipleCellUdf(range as ListRange)//correct if wrong
Plzz explain this function with code.
Condition is if i write tehe function as =FillMultipleCellUdf(5) in CELL A1.
Then
A2=2
A3=3
A4=4
A5=5.

waiting for response...plzzz