Recent Comments
Category Archives: Excel
A Sort Function
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
By Jingo
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
Writing an array to a worksheet range – correction
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
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 Evaluate, Excel, numerical integration, Simpson's Rule, UDF, VBA
2 Comments
Splitters!
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
