Category Archives: VBA

CSpline and Malware

Posted on 13/03/2021 by dougaj4

I was recently informed that the Malwarebyte program was raising a warning for the CSpline2 download. On checking I found that the spreadsheet had a VBA module called frmPickwb which was not my code. The file has now been updated, … Continue reading →

Posted in Computing - general, Curve fitting, UDFs, VBA | Tagged , , | Leave a comment

Lambda and VBA

Posted on 28/02/2021 by dougaj4

The new Excel Lambda function (see here for more details and links) is currently only available to those signed up to the Beta Preview version of Excel 365, but is has been favourably reviewed by almost all of those who … Continue reading →

Posted in Computing - general, Excel, UDFs, VBA | Tagged , , , , | 1 Comment

Eval and Let examples

Posted on 21/02/2021 by dougaj4

Final example updated 28th Feb 2021, following comment from Craig: There are many examples of the use of the new Let function on the web (see my previous post on this topic for links). This post compares use of Let … Continue reading →

Posted in Excel, Maths, UDFs, VBA | Tagged , , , , , | 9 Comments

Python optional arguments from Excel – Part 2

Posted on 19/01/2021 by dougaj4

The previous post provided a method for using pyxll to pass optional arguments from Excel to Python whilst preserving the default values of any called Python function for arguments that were omitted in the Excel function. One condition where this … Continue reading →

Posted in Excel, Link to Python, NumPy and SciPy, PyXLL, UDFs, VBA | Tagged , , , , , | Leave a comment

Units4Excel Update

Posted on 29/12/2020 by dougaj4

As discussed here, I have updated the Units4Excel spreadsheet, with the list of non-SI units updated from the latest Wikipedia table. The EvalU user defined function (UDF) has also been modified with three output options, as shown in the screen-shot … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , , | 5 Comments