Recent Comments
Author Archives: dougaj4
Arc-spline update
The input for the first version of the Arcspline function required the coordinates of the centre of each arc, as well as the angle of the tangents at each end of the arc. I have now added a new version with … Continue reading
Posted in Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA
Tagged Arc-spline function, Excel, IP2.xlsb, UDFs, VBA
Leave a comment
Using Redim and 3DFrame
I recently received a query about the 3DFrame spreadsheet failing to run. The problem was that the code was trying to Redim an array that had not been previously created with a Dim statement. This does not cause a problem … Continue reading
Using VBA Evaluate as an Array Function
I recently discovered from a thread at Chandoo’s Excel Forum that the VBA Evaluate function can be used as an array function. As a simple example: Range(“A11:A16”).Value = Evaluate(“= B11:B16 + C11:C16”) will add the values in columns B and C, … Continue reading
Posted in Arrays, Coordinate Geometry, Excel, Maths, UDFs, VBA
Tagged array functions, Evaluate, Excel, UDFs, VBA
2 Comments
Arcs and arc-splines
I have added two user defined functions (UDFs) to the IP2 spreadsheet to generate coordinates for a single arc, or a series of arcs connected (if necessary) by straight lines. The new version may be downloaded from: IP2.zip As an example … Continue reading
New Tricks …
… or in some cases, old but forgotten tricks. The first comes from a Quora question, asking for the most underutilised feature in Excel. When de-bugging a VBA routine you can set a break point where the code will stop: … Continue reading
Double Bass
Reading the comments on a Davey Graham YouTube video: I discovered that the bass player on the track was Danny Thompson, and checking the other artists playing on the album, “Large and Life and Twice as Natural”, I found they … Continue reading
Posted in Bach
Tagged Bach, Bruton Town, Danny Thompson, Davey Graham, Dick Heckstall-Smith, Double Bass, Jack Bruce, Jon Hiseman
Leave a comment
VBA vs Power Query vs Python
A recent post at Chandoo’s Excel Forum asked for a formula to extract all pairs of digits from a number with 4 digits. This was soon extended to dealing with longer numbers, and the examples looked at here will work with … Continue reading
Posted in Arrays, Excel, Link to Python, UDFs, VBA, xlwings
Tagged Chandoo, Excel, itertools, Power Query, Python, UDF, VBA, xlwings
Leave a comment
