Macro to Convert Value to Number, Sort, then Delete
Today I have these results:
Your code: 203762 milliseconds
My code: 200895 milliseconds
I only tried both versions once.
Thanks for running the test, I appreciate it. Seems like the two methods are
reasonably equivalent, speed-wise, differing by about 3 seconds out of about
200 total seconds.
Rick Rothstein (MVP - Excel)
|