This section looks at how to exercise a workbook to identify the calculation speed of every single column, and also covers how to profile Vba code to identify poor performers. This is useful not only for tuning, but also for soak testing (were all code branches executed as often as you expected). This section is about optimizing Excel and VBA. If you are looking for Google Apps Script items on this topic try Optimizing access to sheet values or Apps Script timer collection

    VBA and garbage collection

    Profiling and timing

In the meantime why not join our forum,follow the blog or follow me on twitter to ensure you get updates when they are available.  

You want to learn Google Apps Script?

Learning Apps Script, (and transitioning from VBA) are covered comprehensively in my my book, Going Gas - from VBA to Apps script, All formats are available from O'ReillyAmazon and all good bookshops. You can also read a preview on O'Reilly

If you prefer Video style learning I also have two courses available. also published by O'Reilly.
Google Apps Script for Developers and Google Apps Script for Beginners.