Home

---

1. Intro

It is easy to lapse into bad programming habits when working with small macros, but with large macros and macros that run a long time, it is critical to use efficient coding. I have collected several tips and tricks about VBA performance improvements. When there are two ways to obtain the same result, I tested the timing difference with the class cPerformanceMonitor to assess their impact.

The results are classified as follows:

---

2. A quick guide for performance-savvy programmers

• Working with strings
  • Use vbNullString instead of ""
  • Fixed-length strings vs variable-length strings
  • Testing an empty string: different methods
  • String functions: $ vs $-less
  • Concatenate strings using Mid$ Function
  • Convert to string: Str$ vs CStr
  • The fastest way to swap strings
• Writing code
  • Reduce the number of lines using comma "," or colon ":"
  • Use "With" statement
• Miscellaneous
  • Edit recorded macros

---

Home