This section is all about performance analysis, tips and tricks for getting the best out of both Apps Script and Excel.

Analysis Results

Tools

Techniques

Using array formulas to improve performance

In Getting insights into Sheets performance I mentioned that I was taking a look under the covers of Sheets to ...

Strings and garbage

VBA has a garbage collector that runs from time to time in order to free up memory that is no ...
For more like this, see Google Apps Scripts Snippets

Why not join our forum, follow the blog or follow me on Twitter to ensure you get updates when they are available.