Category Archives: Excel

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

Two new blogs

Posted on 17/06/2013 by dougaj4

Two new Excel/computer related blogs that I have found recently are: Useful Gyaan (Sharing Stuff to Make life @ work easier) and MS EXCEL UNPLUGGED (which looks like a good resource on using pivot tables) In the near future I will be … Continue reading →

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

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 Goal Seek on a multi-column range

Posted on 20/05/2013 by dougaj4

Following a comment requesting help using my Goal Seek spreadsheet I have modified the macro to allow it to operate on a multi-column range.  The spreadsheet can be downloaded from GSeek.zip, including the solution to the problem described below. The … Continue reading →

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