Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.. :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
writing an formulae with variable parameters | Excel Worksheet Functions | |||
Variable number of parameters in Excel User Defined Function | Excel Programming | |||
SUBSTITUTE formula -- variable spacing between parameters?? | Excel Worksheet Functions | |||
OnAction of Menu Bar with variable parameters | Excel Discussion (Misc queries) | |||
Set up OnAction of a Menu Bar button to a function with variable in the parameters | Excel Discussion (Misc queries) |