Hi KVS Sir,
I acknowledge your code.
But I tested both and Mine is 3 secs faster than yours. ( with due respect )
your was 9 secs.
mine was 6 sec
I have run both five times.
The Speed may vary PC to PC.
I am attaching the file having both the Codes.
In sheet 2 I have arranged the test.
2500 rows of data.
Just select the formula range and run the RangeTimer code in the macro.
May be you have other ideas so test in your way.
Bookmarks