Category Archives: UDFs

Using Index() as an array function

Posted on 23/06/2013 by dougaj4

As promised, this post looks at using the Excel built in Index() function to operate on arrays; it also provides a VBA user defined function (UDF), VBIndex, which simplifies working with arrays within VBA, and also provides improved functionality when … Continue reading →

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

Writing an array function from VBA

Posted on 09/06/2013 by dougaj4

I have covered the topic of writing VBA arrays to a spreadsheet range quite frequently here.  As a reminder, the procedure is: ReDim myarray(1 To NumArrayRows, 1 To NumArrayColumns) ‘ Fill array With Range(“MyNamedRange”) .ClearContents .Resize(NumArrayRows, NumArrayColumns).Name = “MyNamedRange” End … Continue reading →

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , | 1 Comment

Using RC Design Functions – 3

Posted on 08/06/2013 by dougaj4

In the previous post in this series I looked at the results available from the EStress function in the RC Design Functions spreadsheet.  Three associated functions are: EstressCap PLCurve TStiff EStressCap finds the maximum bending moment for a specified axial load, … Continue reading →

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , , , | 1 Comment

Using RC Design Functions – 2

Posted on 18/05/2013 by dougaj4

In the previous post we looked at a summary of the functions in the RC Design Functions spreadsheet, and ways of using the EStress function (download file with examples).  In this post we will look in more detail at the … Continue reading →

Posted in Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , | 1 Comment

Using RC Design Functions – 1

Posted on 10/05/2013 by dougaj4

Download RC Design Functions (includes full open source code) and EStress Examples.xlsx This series of posts will cover ways of using the many functions contained in the RC Design Functions spreadsheet, starting with some general comments on using the User … Continue reading →

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , | 13 Comments