Author Archives: dougaj4

All men will be sailors then, until the sea shall free them

Posted on 14/03/2012 by dougaj4

The YouTube video of A Sailor’s Life by the Fairport Convention contains the image shown below: I have just discovered that the words are taken from the Leornard Cohen song Suzanne, but of the origin of the image I have … Continue reading →

Posted in Bach | Tagged , , , , , | 1 Comment

Writing Arrays to the worksheet – VBA function

Posted on 12/03/2012 by dougaj4

Previous posts have looked at the VBA code for efficiently writing a VBA array to the spreadsheet as quickly as possible, most recently here. I have now put this code in a function that can be conveniently called from any … Continue reading →

Posted in Arrays, Excel, VBA | Tagged , , , , | 17 Comments

More from the Former Love …

Posted on 07/03/2012 by dougaj4

… with video directed by Kerinne Jenkins (Click on Vimeo to visit site, or click play, then full screen button: Dancing in Silence – The Former Love from Kerinne Jenkins on Vimeo.

Posted in Bach, Films | Tagged , , , | 1 Comment

Getting the address of a selected range

Posted on 01/03/2012 by dougaj4

The Excel Indirect() function allows other functions to use the text in a worksheet cell to define a range, rather than selecting the range, or entering it directly into the function. For instance, if cell A1 contained the text B1:B10, … Continue reading →

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

Newton Excel Shakespeare

Posted on 27/02/2012 by dougaj4

Another excellent link from Al Vachris: Bruce McPherson’s Site This site is all about how to free your Excel data from your desktop and take advantage of web capabilities such as Docs, Maps, Earth , Gadgets, Visualizations and a whole … Continue reading →

Posted in Computing - general, Excel, Javascript, VBA | Tagged , , , , , | 2 Comments