Category Archives: Excel

By Jingo

Posted on 18/03/2009 by dougaj4

Dick Kusleika at Daily-Dose-of-Excel recently posted a video of an animated bingo spreadsheet, using the Jing screen capture program. I had previously posted a still image of my Newton’s Cradle animation, which rather spoils the point, so here it is … Continue reading →

Posted in Animation, Excel, Newton, VBA | 1 Comment

Writing an array to a worksheet range – correction

Posted on 14/03/2009 by dougaj4

The Microsoft Excel blog has some tips for speeding up VBA performance in Excel 2007, which apply equally to earlier versions. The number 2 tip (which in my opinion should have been the number 1 tip, and probably the number … Continue reading →

Posted in Excel, VBA | 6 Comments

Evaluate integrals to a specified tolerance

Posted on 10/03/2009 by dougaj4

A previous post presented a user defined function (UDF) to perform a numerical integration of a function specified as a text string.  The UDF allowed the number of subdivisions of the integration range to be specified, but the number of subdivisions required to … Continue reading →

Posted in Excel, Maths, Newton, UDFs | Tagged , , , , , | 2 Comments

Splitters!

Posted on 07/03/2009 by dougaj4

A recent post on the Tek-Tips VBA forum reminded me that VBA has a split function, which will split a string into sub-strings at any specified character (such as a space).  D’oh I thought, why did I waste my time writing … Continue reading →

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

Frame Analysis with Excel – 5; Large frames in Excel 2003

Posted on 05/03/2009 by dougaj4

Continuing from: Frame Analysis with Excel – 4, 2D frame analysis Download Frame2.zip – the download file includes complete open source code. The solution presented in the previous post in this series made use of the Excel built in functions MINVERSE() and … Continue reading →

Posted in Excel, Frame Analysis, Newton, VBA | Tagged , , , | 5 Comments