Category Archives: UDFs

Debugging VBA – 2

Posted on 11/07/2011 by dougaj4

Following on from the opening post in this series (Debugging VBA) I will now look at the main debugging tools provided in the Visual Basic Editor (VBE): The Immediate Window allows interaction with the code while it is running.  In the … Continue reading →

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

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

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

Using Array Formulas

Posted on 10/05/2011 by dougaj4

Many of my User Defined Functions (UDFs) return an array of values, that requires a special procedure to make all the values visible. I have usually given a brief description of the procedure with the UDF, but for convenience for … Continue reading →

Posted in Arrays, Excel, UDFs | Tagged , , | 20 Comments