One method to benchmark re-written code or debate 'quicker' methods is to use VBA's built-in timer.

Macros make it wonderfully easy to automate repetitive tasks in Excel, but the way they're created and the facilities for using them are sometimes problematic. Fortunately, Excel is flexible enough that you can fix those problems and create new features with a minimum of effort.