Performance

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
  • Strings and garbage the performance of the garbage collector in VBA is ... garbage. Here's how to get round it.

For more like this, see Google Apps Scripts snippets. Why not join our forumfollow 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.




Comments