user defined function Archives • My Online Training Hub

November 24, 2017

Writing UDFs in Excel With Python

My last post looked at using Python to plot equations in Excel with DataNitro. In this one I want to

January 31, 2017

This post is going to look at how to return an array from a udf. My last post looked at

January 24, 2017

I've previously written a UDF to count colored cells and then perform various maths functions on the values in those

November 11, 2016

In a previous post I discussed storing your UDF's in PERSONAL.XLSB so that you could use them in any workbook.

October 27, 2016

You've created your own PERSONAL.XLSB and want to use it to store VBA that you are going to use all

September 21, 2016

My last post looked at creating a simple user defined function (UDF). This post looks at a little more advanced

September 15, 2016

Any user of Excel will have used its functions. From the humble SUM to VLOOKUP, INDEX and MATCH, OFFSET and