Category Archives: UDFs

Dealing with dates 2: Getting cell data type and format code

Posted on 08/06/2015 by dougaj4

When working with imported data, or data from an opened csv file, it is often important to know the data type that has been used to store the data.  This may not be obvious, for instance in the previous post we … Continue reading →

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

Reversing Bob

Posted on 31/05/2015 by dougaj4

Following our look at Weird Al Jankovic’s palindromic song, Bob, I have written two short VBA User Defined Functions (UDFs) to help writing palindromes (and possibly with other tasks as well). Reverse() will, as the name suggests, reverse any text entered as … Continue reading →

Posted in Excel, Link to Python, UDFs, VBA | Tagged , , , , , | Leave a comment

xlSciPy 1.01

Posted on 05/05/2015 by dougaj4

The xlSciPy spreadsheet, introduced here, has been updated with many new functions.  The new version, including full open source code (VBA and Python) can be downloaded from: xlSciPy.zip The spreadsheet requires Python to be installed, including NumPy and SciPy.  It … Continue reading →

Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA | Tagged , , , , , , | Leave a comment

Time to Lookup

Posted on 27/04/2015 by dougaj4

At Daily Dose of Excel Jeff Weir has been looking at alternative methods of applying the VLookup function and ways of getting precise timing of the different formulations. Based on his posts there I have written two Lookup User Defined … Continue reading →

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , , , , | 5 Comments

Re-sizing Array Functions

Posted on 14/04/2015 by dougaj4

The recent updates to the ConBeamU spreadsheet contained two new functions for entering and re-sizing array functions, and since they will be useful on any spreadsheet containing array functions (which here means almost all of them) I thought they deserved … Continue reading →

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , , , , | 4 Comments