How to determine the column letter from Cell address
"keepITcool" skrev i en meddelelse
.com...
Leo,
following works in all excel versions and is even
a bit (30%) faster than your elegant split trick
Wow, 0.7 nanosecs instead of 1 :-)
Elegant, yes, but unfortunately not mine.
I'm not sure, but I believe it was conjured up
by Dana DeLouis years ago.
Leo
|