Author Archives: dougaj4

A Sailor’s Life

Posted on 04/05/2011 by dougaj4

A Sailor’s Life was recorded by Fairport Convention in 1968 and marks the transition of the group from a pale copy of the American West Coast sound to an original and innovative re-interpreter of British folk songs.  At the time … Continue reading →

Posted in Bach | Tagged , , , , , , | 2 Comments

Showing numerical values of formulae cell references

Posted on 28/04/2011 by dougaj4

This post follows from a discussion at Eng-Tips The original question was for a way of displaying the value of each component of an Excel formula.  It is easy to display the formula, rather than the result, for all the … Continue reading →

Posted in Excel, VBA | Tagged , , , , | 9 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

XLW

Posted on 13/04/2011 by dougaj4

Prompted by a thread at The Wilmott Forums that linked here, I was prompted to take a look at XLW- A Wrapper for the Excel API.  This is what they say about themselves: “XLW is an open source application that … Continue reading →

Posted in Excel, Link to dll | Tagged , , | Leave a comment