Category Archives: UDFs

Using Array Formulas

Posted on 10/05/2011 by dougaj4

Many of my User Defined Functions (UDFs) return an array of values, that requires a special procedure to make all the values visible. I have usually given a brief description of the procedure with the UDF, but for convenience for … Continue reading →

Posted in Arrays, Excel, UDFs | Tagged , , | 20 Comments

Beware of the mod

Posted on 22/04/2011 by dougaj4

Playing with a simple VBA user defined function (UDF), inspired by a thread at Daily Dose of Excel, I was finding it was mysteriously giving the wrong answer. The task was to find the angle between the hands of an … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , | 2 Comments

Calling Add-in functions from VBA

Posted on 16/04/2011 by dougaj4

When an Excel add-in is active any User Defined Functions (UDFs) in the add-in are available to any other open worksheet.  It might be expected that the same would apply to VBA routines defined in other files, but if you … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , , | 2 Comments

Tanh-Sinh Quadrature V2.0

Posted on 04/04/2011 by dougaj4

I recently received an update of the Tanh-Sinh Quadrature spreadsheet from Graeme Dennes, which can be downloaded from:  Tanh-Sinh Quadrature (including, as usual, full open source code). – Link fixed 5th April 2011 Here is Graeme’s description of the updates: The … Continue reading →

Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA | Tagged , , , , | 2 Comments

PView Function

Posted on 31/03/2011 by dougaj4

As promised in the previous post, here are further details of the PView User Defined Function (UDF), included in the IP2 spreadsheet, which can be downloaded (including full open source code) from IP2.ZIP. The PView UDF works by multiplying the 3D … Continue reading →

Posted in Arrays, Charts, Charts, Coordinate Geometry, Drawing, Excel, Maths, UDFs, VBA | Tagged , , , , , , | 3 Comments