Category Archives: Arrays

Solving simultaneous equations

Posted on 27/08/2008 by dougaj4

Solving a series of simultaneous equations is a task frequently required in engineering and scientific analysis.  Excel provides the tools to perform this task quickly and easily, but the procedure is not documented in the on-line help (so far as … Continue reading →

Posted in Arrays, Excel, Maths, UDFs, VBA | Tagged , , , , | 5 Comments

Section Properties UDF and UDF charting

Posted on 14/03/2008 by dougaj4

The technique for calculating section properties from coordinates is conveniently coded into a UDF: Function Area(xy_range As Variant) As Double Dim XYcells As Variant Dim N As Long, NumX As Long Dim XD As Double, YSum As Double XYcells = … Continue reading →

Posted in Arrays, Charts, Excel, UDFs | Tagged | 6 Comments

Ranges and Arrays – 2

Posted on 05/03/2008 by dougaj4

Yesterday we looked at how to get data from a worksheet range into a VBA array.  Today’s post looks at the opposite operation; writing an array to a worksheet range.  With a UDF it couldn’t be simpler: Function MyFunction() as … Continue reading →

Posted in Arrays, Excel, UDFs | 1 Comment

Ranges and Arrays

Posted on 04/03/2008 by dougaj4

Transferring data from a worksheet into a VBA routine, or the other way round, is one of the most frequent tasks carried out in VBA programming.  Fortunately there is a simple way to do it: In a subroutine: Name the … Continue reading →

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