Monday, June 27, 2011

Excel counts columns Count With Letters Extension


Should you need to count as Excel counts columns, then look at Zeltera's "Count with Letters".
His routines can be extended to convert an Integer to an Excel Column or an Excel Column to an integer. A long time ago, I wrote two very simple, inefficient loop wrappers around Zeltera's core code to do just that. Here I present a way to calculate a result, so as to reduce the loop to no more than 26 passes.
 
 
http://www.codeproject.com/KB/cs/CountWithLettersExtn.aspx

No comments: