Recent Comments
Category Archives: Arrays
Compiled AlgLib Matrix Functions for Excel
This post describes a series of matrix functions compiled from the AlgLib library code (covered in previous posts) as a dll that can be called from Excel VBA, and used as User Defined Functions (UDFs). A spreadsheet containing the necessary VBA … Continue reading
Posted in Arrays, Excel, Link to dll, Maths, Newton, UDFs, VBA
Tagged AlgLib, C++, dll, Excel, Matrix Functions, UDF, VBA
18 Comments
Installing AlgLib with Excel VBA
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 AlgLib, Eigen values, Excel, Inverse, linear algebra, Matrix, UDF, VBA
13 Comments
Calling a function as a variable
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 application.run, calling a function, equation solver, Excel, iteration, UDF, VBA
6 Comments
Some VBA maths resources
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
Transferring data with arrays
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
Newton Excel Bach, not (just) an Excel Blog 