Category Archives: VBA

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

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

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