I have a class that im used for user-defined tasks in Excel. Classroom is installed and available as an automation object.
I have no problem creating a function with one or more parameters. And none of the problems are as a result of returning arrays and 2 dimensional arrays.
Although I'm trying to set up a function that can take variable parameters, but the result always returns back to Excel as #VALUE.
> Public Object Test Function (Parameters Double [] Value) {Return Value. Long; } Is the parameter really possible to work in Excel called?
No comments:
Post a Comment