Functions without argument shows a default entry in the wizard

Feb 5, 2014 at 12:23 AM

I am using Excel DNA extensively in my project to support UDF. One thing I have noticed that for functions without arguments the function wizard ends up showing a blank field with no argument name. Where as for built in functions with no arguments, the wizard does not show this redundant entry.

Is it an Excel DNA limitation? Or is it not possible to avoid this behavior for UDF in general?

Prajnan Das
Feb 5, 2014 at 7:41 AM
OK got it - it's an Excel bug. Only way to circumvent it is leaving the function description empty.