How to measure Performance Impact by Time and Test Each Change in Excel Web ?

Brass Contributor

Is there Desktop VBA equivalent to "Time and test each change" provided by URL below?

https://learn.microsoft.com/en-us/office/vba/excel/concepts/excel-performance/excel-improving-calcul... 

Quoted from URL:

Fourth rule: Time and test each change

Some of the changes that you make might surprise you, either by not giving the answer that you thought they would, or by calculating more slowly than you expected. Therefore, you should time and test each change, as follows:

  1. Time the formula that you want to change by using the RangeTimer macro.

  2. Make the change.

  3. Time the changed formula by using the RangeTimer macro.

  4. Check that the changed formula still gives the correct answer.

0 Replies