View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Leo Heuser Leo Heuser is offline
external usenet poster
 
Posts: 266
Default 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