Quick Links

Other stuff

Site owners

  • Bruce Mcpherson

Services‎ > ‎Desktop Liberation‎ > ‎

Optimization

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.