Making VBA run faster

Sometimes you have a spreadsheet that just takes forever to run VBA reports, even though you’ve tried all the usual tips and tricks. This post shows one reason I found and how I managed to fix it.I have a workbook I’m using for some life cycle cost and life cycle carbon footprint analysis. The basis […]

Sorting functions for VBA

One of the things I find most frustrating about VBA for Excel is the lack of a native sorting method for arrays. Perhaps it’s because there’s the option of sorting it on the worksheet, but that’s not always viable.This post is mainly just a store for VBA implementations of sorting algorithms and will probably be […]

“My location” function for Excel

If you downloaded the example file I posted earlier on today, as well as a few updates to the simple versions of the Gmaps and geolocation functions for Excel, you may have noticed that one of the places on the clickable list of locations was “My location”.This works using Wikimedia’s geoiplookup service. When I visit […]

Google Maps and Excel download

I was asked for a downloadable file with the G_LATLNG function by Filipe who was having trouble getting the function working. Since I posted that, I’ve done a bit of further work to improve it. The workbook you can download caches results from G_LATLNG and G_DISTANCE queries to reduce the amount of time spent polling […]