What can you do with this?

  • Profile Workbooks
  • Profile Code
  • Automatic Code Profiler

It’s all about optimisation

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 Optimization

    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.