Author Archives: dougaj4

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

4 Year Report

Posted on 25/02/2012 by dougaj4

As in previous years, I have downloaded the statistics for this blog for the previous year, and pasted them into a worksheet. The link to each post is preserved in the spreadsheet, so it makes a convenient index to what … Continue reading →

Posted in Excel | Tagged | Leave a comment

Strand7 API GetNode functions

Posted on 19/02/2012 by dougaj4

As promised in this post, I have written and documented Excel User Defined Functions (UDFs) to interface with all the Strand7 API functions that return node attributes or results.  These 22 functions allow node attributes and results to be read directly … Continue reading →

Posted in Excel, Finite Element Analysis, Newton, Strand7, UDFs, VBA | Tagged , , , , , | 5 Comments

Embedding Skydrive worksheets in WordPress

Posted on 16/02/2012 by dougaj4

On the Download page of this blog I have a list of files available for download, in the form of an Excel spreadsheet stored on the Microsoft Skydrive site.  I recently discovered that this link had stopped working, and that the … Continue reading →

Posted in Computing - general, Excel | Tagged , , , , | 9 Comments