Search results for query: *

Thanks, xwb... I'm an idiot. I was overly tired and misread C# documentation regarding equality comparison. I corrected mistakes and compiled without a problem, but I was getting a weird error from Excel. I tracked it down to one of the argument definitions and changed it from "byte" to "int"...

I'm playing around with a class library in Visual Studio, integrating ExcelDNA to make a (few) User Defined Function for Excel. The only error I am receiving is for the top "public static string StrCase" statement, but I haven't been able to figure out what the problem is. What do I need to do...

Thanks for the reply, combo, but no banannas. What you described is the behavior that I would expect to get from Excel, but Excel is still inserting This morning, I had a Teams call with a coworker. We checked that person's computer to make sure we had the same XLAM file on our local...

I am not too familiar with Excel add-ins, but I have a simple XLAM add-in that has a few different User Defined Functions (UDFs). I've shared this XLAM with a few people. And, when they open up a workbook where I inserted a UDF, even when they have the add-in installed and activated, Excel is...

I'm new to developing Excel AddIns with C#. I've been doing basic programming in VBA for a few years, but wanted to check out the C# capabilities. And I stumbled over this tutorial and tried it out...

A few months ago, I wrote a UDF that has generally been working the way I want it to. The UDF is similar to the standard Excel FORMULATEXT() function, but it displays the cell values/contents instead of the cell address. I just noticed, while working with a large table of data with some hidden...