Category Archives: Excel

A problem with integers in VBA

Posted on 01/10/2019 by dougaj4

A recent question at Quora asked: “Why am I getting an overflow error in Excel VBA when doing a simple arithmetic calculation like str1 = 24*60*30 where str1 is a variant or long or double?” I hadn’t encountered that problem … Continue reading →

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

The answer to Life the Universe and Everything …

Posted on 19/09/2019 by dougaj4

is 42, as is well-known: The actual question, to which the answer is 42, is not known, but a lesser known long standing question involving this number has recently been solved: The original problem, set in 1954 at the University … Continue reading →

Posted in Computing - general, Excel, Maths, Newton, PyXLL | Tagged , , , , | 5 Comments

Plotting Mandelbrot

Posted on 15/09/2019 by dougaj4

There are many sites discussing the Mandelbrot Set, but not many examples using VBA to plot the set in Excel, so here is my effort: The spreadsheet (including open source VBA code) may be downloaded from: Mandelbrot chart.zip Note that … Continue reading →

Posted in Charts, Charts, Coordinate Geometry, Drawing, Excel, Maths, Newton, VBA | Tagged , , , | 3 Comments

Using conditional formatting with array formulas

Posted on 17/08/2019 by dougaj4

A recent Quora question asked “How do I highlight the number closest to an initial number in a row in Excel?“.  The answer by Bill Jelen provides a good example of using conditional formatting with an array formula: In my … Continue reading →

Posted in Arrays, Excel | Tagged , , , | Leave a comment

64 bit Excel and the Strand7 API

Posted on 13/08/2019 by dougaj4

Back in May 2017 I posted a sample spreadsheet using the Strand7 API to allow Excel to read and write Strand7 node data and results.  A comment noted at the time that the spreadsheet was not working with 64 bit … Continue reading →

Posted in Excel, Finite Element Analysis, Frame Analysis, Link to dll, Newton, Strand7 | Tagged , | Leave a comment