Tag Archives: Excel

Links on Lists, and other things.

Posted on 31/01/2015 by dougaj4

Daily Dose of Excel recently had a post on interacting with List Objects from VBA.  Since I make very little use of Lists (or Tables as they are now known in Excel, but not VBA), I thought I’d have a search … Continue reading →

Posted in Computing - general, Excel, VBA | Tagged , , , , | 2 Comments

Smart Indenter and Excel 2013

Posted on 27/01/2015 by dougaj4

I have recently installed Office 365 on a new computer running Windows 8.1 (actually the third one in just over a month, but that’s another story).  Office 2013 has several annoying features, but for me the most annoying was that … Continue reading →

Posted in Computing - general, Excel, VBA | Tagged , , , , , | 26 Comments

Finding Excel Version Information

Posted on 26/01/2015 by dougaj4

The information below was buried in an old post, but I had trouble finding it when I wanted it, so here it is in its own post: Finding the version information in Office used to be easy; it was always … Continue reading →

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

Numerical Integration; Tanh-Sinh Quadrature v. 4.3

Posted on 29/12/2014 by dougaj4

A new version (4.3) of the numerical integration spreadsheet by Graeme Dennes is now available for download from Tanh_Sinh Quadrature. The Tanh-Sinh Quadrature Version 4.3 workbook now provides a feature for the integration of integrands contained in independent (external) UDFs. … Continue reading →

Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA | Tagged , , , , , , , , | 6 Comments

Numpy and Scipy for Excel

Posted on 14/12/2014 by dougaj4

The Python Numpy and Scipy libraries contain a huge number of maths and science related functions.  Most of these are not directly available from Excel, but using the free ExcelPython package it is fairly easy to make the link, vastly increasing … Continue reading →

Posted in Excel, Link to Python, Maths, NumPy and SciPy, UDFs, VBA | Tagged , , , , , , | 11 Comments