user defined function

This post is going to look at how to return an array from a udf. My last post looked at how to return a range from a UDF and in that, I included a small, bonus function which gave you the interior color of a cell. I'm going to modify that function so it becomes …

I've previously written a UDF to count colored cells and then perform various maths functions on the values in those cells, like SUM, AVERAGE or COUNT. In this post I'm going to rewrite that code so that we can return a range from a UDF. This range contains all the cells that match the reference …

In a previous post I discussed storing your UDF's in PERSONAL.XLSB so that you could use them in any workbook. You do run into a problem with this though in that unless you create a reference to PERSONAL.XLSB, every time you want to use your UDF, you need to precede the function name with PERSONAL.XLSB!. …

You've created your own PERSONAL.XLSB and want to use it to store VBA that you are going to use all the time. Sounds cool. You are really keen to know what the cube of numbers are so you write this function and place it into a module in PERSONAL.XLSB. Function cube(number As Long) As Long …

My last post looked at creating a simple user defined function (UDF). This post looks at a little more advanced subject of combining multiple functions into one multi function UDF. Sometimes you’ll write code to do similar jobs. Maybe one function to remove alpha characters (letters) from a string, and another to remove non-numeric characters. …

Any user of Excel will have used its functions.  From the humble SUM to VLOOKUP, INDEX and MATCH, OFFSET and myriad others. Excel also allows you to create your own functions, these are known as user defined functions, or UDF’s. By creating a UDF you can expand the functionality of Excel and get it to …