VBA and garbage collection
Profiling and timing
- Execution Time Logging: A workbook analyzer you can use to see where your spreadsheet is spending its calculation time – minimal VBA knowledge needed
- Simple profiling of your user defined functions: For VBA developers with beginner skills upwards, measuring efficiency of you code.
Automatically profiling your procedures: For VBA developers with beginner skills upwards, a quickstart to measuring efficiency of you code
- Advanced Profiling: Rogue Use Case Identification: A Procedure Profiler: For VBA developers with intermediate skills upwards, for drilling into code roadblocks
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’Reilly, Amazon and all good bookshops. You can also read a preview on O’Reilly