Where is that code from and how are you invoking it in Excel when it
works as a stand alone?NA_AB;162105 Wrote:
hey friends,

public int addme(params object[] list)
{
// sum all the integers included in list
int sum = 0;
foreach (object o in list)
if (o.GetType() == typeof(int))
sum += (int)o;
return sum;
}

this code works fine as a stand alone code but when am trying to invoke
the
"addme" function from excel by saying "=addme(10,20,30)" or
"=addme(10,20)"
in the excel cell, it is not returning me the sum. All I see is
"#VALUE!" in
that excel cell.

kindly let me know what should be done in this regard...


--
The Code Cage Team

Regards,
The Code Cage Team
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=45076

this code when written in a simple console application and when this
function is called, it is getting executed perfectly with variable number of
arguments.

But, when am using the same code in "connect.cs" of the excel addin project,
and invoking this function from MS Excel(2003) as '=addme(10,20)' or
'=addme(10,20,30)' it is not giving any result, it is simply showing a
"#VALUE!"

thanks in advance... any help is considered very thankful..