Tag Archives: VBA

Using LatPilePY

Posted on 09/07/2011 by dougaj4

LatPilePY is a User Defined Function (UDF) used to analyse the deflections and load actions in laterally loaded piles.  It was presented in this post: LatPilePY.  In response to an e-mail request, this post will give step by step instructions for … Continue reading →

Posted in Arrays, Concrete, Excel, Geotechnical Engineering, Newton, UDFs, VBA | Tagged , , , , , , | Leave a comment

Debugging VBA …

Posted on 22/06/2011 by dougaj4

… especially User Defined Functions (UDF’s). This post (and most likely several to follow) was prompted by a recent discussion at Daily Dose of Excel about various alternative debugging techniques.  It reminded me (if I had ever known) of the Debug.Assert … Continue reading →

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

High Speed Blog …

Posted on 07/06/2011 by dougaj4

… brought to you via Smurf on Spreadsheets If you want your spreadsheets to go faster, Charles Williams is the man to tell you how to do it.  Charles has recently started a blog on the subject: FastExcel Well worth … Continue reading →

Posted in Excel, VBA | Tagged , , | Leave a comment

Using LinEst() on data with gaps

Posted on 14/05/2011 by dougaj4

A comment on Using LINEST for non-linear curve fitting asked if it was possible to use the function on data with gaps.  There are several options: Copy and sort the data to remove the gaps. Use the chart trendline function Use … Continue reading →

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

Showing numerical values of formulae cell references

Posted on 28/04/2011 by dougaj4

This post follows from a discussion at Eng-Tips The original question was for a way of displaying the value of each component of an Excel formula.  It is easy to display the formula, rather than the result, for all the … Continue reading →

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