Top "Excel-udf" questions

User-defined functions (UDFs) are VBA procedures that typically take inputs (although inputs are not mandatory) to return a result to either a worksheet cell, or to another VBA procedure.

Function to convert column number to letter?

Does anyone have an Excel VBA function which can return the column letter(s) from a number? For example, entering 100 …

excel vba excel-udf
function to convert String to upper case

I have been trying to make a user defined function I wrote return it's value in all upper case, using …

vba excel excel-udf
Formula to eliminate all but alpha characters

I need to scrub a column of names in Excel to eliminate all non-Alpha characters including periods, commas, spaces, hyphens …

excel excel-formula substitution excel-udf vba
How do I create a real-time Excel automation add-in in C# using RtdServer?

I was tasked with writing a real-time Excel automation add-in in C# using RtdServer for work. I relied heavily on …

c# vsto excel-addins rtd excel-udf
What does "Microsoft Office Excel is waiting for another application to complete an OLE action." mean?

I have a working RTD Excel automation add-in similar to the one described here. Intermittently, while attempting to load a …

excel user-defined-functions rtd excel-udf vba
UDF to remove special characters, punctuation & spaces within a cell to create unique key for Vlookups

I hacked together the following User Defined Function in VBA that allows me to remove certain non-text characters from any …

vba excel vlookup excel-udf
Excel UDF not appearing in drop down menu

I wrote a User Defined Fucntion in Excel. It works great with no issues. I even wrote a description for …

excel excel-2007 excel-udf vba