Monthly Archives: October 2017

Tables and VBA

I don’t use Excel Tables much, and not at all from VBA (where they are known as ListObjects), but that should probably change, so here are four links with comprehensive help on using Tables from VBA: The Spreadsheet Guru- VBA … Continue reading

Posted in Arrays, Excel, VBA | Tagged , , , , | 5 Comments

A Hard Rain

I happened to be looking at an old post here; Various routes to and from Nottamun Town, featuring Bob Dylan’s performance of A Hard Rain’s Gonna Fall, which led me to Patti Smith’s performance of the same song at last year’s … Continue reading

Posted in Bach | Tagged , , , | Leave a comment

Using Flash Fill

There have been several posts here on using functions or user defined functions (UDFs) to extract text or numbers from a longer string (most recently, here), but for many purposes it is quicker and easier to use the “flash-fill” feature, … Continue reading

Posted in Excel, UDFs, VBA | Tagged , , , | 1 Comment

Hofstadter, Pahud, Bach

The latest ACO concert series features the Swiss flautist Emmanuel Pahud (interview here). The performance included J.S. Bach’s 6 Part Ricercar, from The Musical Offering, which was the inspiration for the final dialogue in Douglas Hofstadter’s Godel, Esher, Bach: Achilles … Continue reading

Posted in Bach, Maths, Newton | Tagged , , , , , | Leave a comment