Category Archives: Arrays

Installing AlgLib with Excel VBA

Posted on 20/05/2010 by dougaj4

In a previous post I linked to the AlgLib site which has an extensive range of mathematical routines available in VBA, c/c++ and pascal.  I have recently been experimenting with these (in reponse to a thread at the Eng-Tips forum), and will … Continue reading →

Posted in Arrays, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , , | 13 Comments

Calling a function as a variable

Posted on 08/04/2010 by dougaj4

The functions described in recent posts provide iterative solutions to polynomial equations, but the same method can be used for any equations that can be evaluated numerically and have a single variable.  The question then is, how can we call a … Continue reading →

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

Some VBA maths resources

Posted on 01/04/2010 by dougaj4

In the past week I have discovered a couple of  sites with open source maths related VBA code that I was previously unaware of, and which deserve to be better known: AlgLib: “ALGLIB is a cross-platform numerical analysis and data processing library. … Continue reading →

Posted in Arrays, Excel, Maths, VBA | Tagged , , | 4 Comments

Transferring data with arrays

Posted on 22/03/2010 by dougaj4

The earlier post: Transferring data within VBA looked at some important aspects of transferring data between subroutines in Excel VBA.  This post will look at arrays in particular, and some peculiarities that affect the way they work. VBA arrays are a very … Continue reading →

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

The speed of loops

Posted on 07/03/2010 by dougaj4

Commenting on the Good Practice post, John Tolle pointed out that with a collection it was very much quicker to loop using a For each loop than iterating by index, using a for, next loop.  I did some simple tests on this, … Continue reading →

Posted in Arrays, Excel, VBA | Tagged , , , , , | 8 Comments