Search code examples
c#excel-interopexcel-addinsexcel-udf

Excel Automation Addin function returing excel range


I am writing a Excel 2003 automation addin using c#.

I have followed this article http://blogs.msdn.com/b/eric_carter/archive/2004/12/01/writing-user-defined-functions-for-excel-in-net.aspx

Every thing works including passing excel range object as parameter. But I wasn't able to return a range object from my function. My knowledge is very limited on the subject matter, will appreciate any inputs.


Solution

  • Since you don't show any source code it is hard to tell what's wrong - for returning Excel Range use object[,] as the return type of your UDF.