TechTalk

One often needs a Excel Column's alphabetic letter from the column number e.g Column No.3 corresponds to ColumnLetter - C      Column No.27 corresponds to ColumnLetter - AA I use the following function to achieve this Public Function ColumnLetter(ColumnNumber As Integer) As String   If ColumnNumber > 26 Then     ' 1st character:  Subtract 1 to map the characters to 0-25,     '                 but you don't have to remap back to 1-26     '                 after the 'Int' operation since columns     '                 1-26 have no prefix letter     ' 2nd character:  Subtract 1 to map the characters to 0-25,   ...