Author Archives: dougaj4

More from June Tabor and Eric Bogle

Posted on 07/09/2014 by dougaj4

No Man’s Land: Well how do you do, young Willie McBride,Do you mind if I sit here down by your graveside And rest for a while ‘neath the warm summer sun I’ve been working all day and I’m nearly done. … Continue reading →

Posted in Bach, Films | Tagged , , , , , , | Leave a comment

Extending complex UDFs with simple VBA

Posted on 05/09/2014 by dougaj4

One of the advantages of writing spreadsheet applications in the form of User Defined Functions (UDFs) is that the UDF may be used on the spreadsheet in the same way as a built-in function, allowing applications to be modified and extended … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | 3 Comments

John Howard, an Apology, and Long Lost

Posted on 04/09/2014 by dougaj4

John Howard is a well known Australian actor.  There is also an Australian ex-Prime Minister by the name of John Howard, but we are not concerned with that one here. In 2000 John Howard (playing the part of an actor … Continue reading →

Posted in Bach, Films | Leave a comment

The Band Played Waltzing Matilda – June Tabor

Posted on 01/09/2014 by dougaj4

Folk singer June Tabor is as far as I’m aware the first artist to record Eric Bogle’s The Band Played Waltzing Matilda. This is in my opinion the definitive version. We are supposed to learn from our mistakes but never … Continue reading →

Posted in Bach, Films | Tagged , , , , | Leave a comment

Using the VBA ParamArray keyword

Posted on 30/08/2014 by dougaj4

The recently posted SolvePoly function makes use of the VBA ParamArray keyword, which allows an arbitrarily long list of arguments to be passed to another function.  I have not made great use of this in the past, but since the … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | Leave a comment