Category Archives: VBA

What is VBA good for? …

Posted on 25/02/2013 by dougaj4

… is the name of a Stackoverflow thread that sends a steady trickle of visitors here (thanks to a link posted by Charles Williams of FastExcel).  On a similar theme, Smurf on Spreadsheets has a post entitled “What’s so good … Continue reading →

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

Using Frame4 for truss analysis

Posted on 21/02/2013 by dougaj4

The Frame4 spreadsheet is set up to allow the analysias of rigid-jointed 2D frames, but it is simple to use it for 2D truss analysis; simply either provide a moment release at each end of every member, or define every member … Continue reading →

Posted in Excel, Finite Element Analysis, Frame Analysis, Newton, VBA | Tagged , , , | 2 Comments

Function to make a list of functions …

Posted on 11/02/2013 by dougaj4

… and other procedures. I wanted to make a list of all the VBA procedures in a workbook, and discovered that Excel doesn’t have a built-in way of doing that.  People have written code to work their way around that of course, … Continue reading →

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

3DFrame v1.01

Posted on 03/02/2013 by dougaj4

The 3D frame analysis spreadsheet has been updated to v1.01, with a correction to the calculation of node reactions.  The previous version gave incorrect results for any restrained node at end 2 of any beam. Please download the new version … Continue reading →

Posted in Excel, Frame Analysis, Newton, VBA | Tagged , , , | 2 Comments

Goal Seek Macro for Multiple Sheets

Posted on 30/01/2013 by dougaj4

Following a comment on the Using Goal Seek on Multiple Cells post, I have modified the macro so that the goal-seek ranges can be on a different sheet to the named input ranges.  The new file can be downloaded from: GSeek.zip. … Continue reading →

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