Category Archives: Excel

7 Year Report

Posted on 24/02/2015 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 Bach, Excel, Newton | Tagged | 2 Comments

Slicing Arrays with VBA

Posted on 20/02/2015 by dougaj4

A recent comment asked about the most efficient way to write part of an array to the spreadsheet from VBA. This post looks at three alternative methods which have advantages in different circumstances (thanks to Lori Miller for reminding me … Continue reading →

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

Beams may kiss, but do not hug …

Posted on 09/02/2015 by dougaj4

… not full length anyway. This post was inspired by a now very long discussion at Eng-Tips on the apparently simple question of what happens when you place one short beam on top of a longer one, and apply a … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, UDFs, VBA | Tagged , , , , , , , | Leave a comment

Links on Lists, and other things.

Posted on 31/01/2015 by dougaj4

Daily Dose of Excel recently had a post on interacting with List Objects from VBA.  Since I make very little use of Lists (or Tables as they are now known in Excel, but not VBA), I thought I’d have a search … Continue reading →

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

Smart Indenter and Excel 2013

Posted on 27/01/2015 by dougaj4

I have recently installed Office 365 on a new computer running Windows 8.1 (actually the third one in just over a month, but that’s another story).  Office 2013 has several annoying features, but for me the most annoying was that … Continue reading →

Posted in Computing - general, Excel, VBA | Tagged , , , , , | 26 Comments