Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 57
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
writing an formulae with variable parameters Formulas with variable parameters Excel Worksheet Functions 2 June 19th 09 06:58 PM
Variable number of parameters in Excel User Defined Function Tony Gravagno Excel Programming 0 December 13th 07 05:33 AM
SUBSTITUTE formula -- variable spacing between parameters?? The Moose Excel Worksheet Functions 6 December 2nd 06 07:00 PM
OnAction of Menu Bar with variable parameters chris Excel Discussion (Misc queries) 1 August 7th 06 04:03 PM
Set up OnAction of a Menu Bar button to a function with variable in the parameters chris Excel Discussion (Misc queries) 0 July 17th 06 05:05 PM


All times are GMT +1. The time now is 11:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"