views:

34

answers:

0

I have a class that Im using for userdefined functions in Excel. The classlibrary is installed and available as an Automation object.

I have no problems creating functions with one or more parameters. And no problems return arrays and 2 dimensional arrays as results.

However Im trying to setup a function that can take variable parameters, but the result always comes back in Excel as #VALUE.

public object TestFunction(params double[] values)
{
     return values.Length;
}

Are params actually possible in functions called by Excel?