ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   a problem with variable number of parameters. (https://www.excelbanter.com/excel-programming/422075-problem-variable-number-parameters.html)

NA_AB[_2_]

a problem with variable number of parameters.
 
hey all, this seems to be working fine,

int Method(params int[] numbers)
{
int count = 0;
foreach (int n in numbers)
{
count++;
}
return count;
}

but,


when am trying to build a com addin to excel, and am trying to invoke this
function using the excel formula way i.e., as =Method(10,20,30) or
=Method(1,2,3,4,5,6) and so on... I'm always getting a '#VALUE!'

WHAT COULD BE THE PROBLEM?! thanks in advance people... any help shall be
considered very thankful.. :)


All times are GMT +1. The time now is 07:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com