Category Archives: Arrays

More on Worksheetfunction vs UDF

Posted on 22/04/2009 by dougaj4

A recent post at Roy Maclean’s VBA Blog suggested that the difference between using a worksheetfunction call in VBA and writing a User Defined Function (UDF) to do the same job was not enough to be worth worrying about.  He tested … Continue reading →

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

A Sort Function

Posted on 23/03/2009 by dougaj4

There is often a need to sort data within a VBA routine, but VBA does not have a built in sort function, so I recently had a look for what is on offer on the Internet. Chip Pearson has an … Continue reading →

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

Repeating a set of data

Posted on 21/01/2009 by dougaj4

The Microsoft Excel Blog has a discussion on ways of repeating a set of data, for instance making three copies of every row of a range of data.  I have written a simple UDF to do this job, and also extract … Continue reading →

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

Solving simultaneous equations – Fortran dll

Posted on 20/12/2008 by dougaj4

The file simultaneous.zip has been modified to allow access to a Fortran simultaneous equation routine, compiled as a dll.  The original file was posted in solving simultaneous equations.  The advantages of a compiled routine include: Much better performance Greater precision through … Continue reading →

Posted in Arrays, Fortran, Link to dll, Maths, UDFs, VBA | Tagged , , , , , | 3 Comments

Finding Prime Numbers with Excel, and using Array Formulas

Posted on 18/11/2008 by dougaj4

Download Primes.zip. Several of the puzzles at Project Euler (see previous post) require the finding of prime numbers, for instance what is the 10,001th prime number?  Searching the Web for some ready made solutions I found this array formula at … Continue reading →

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