Software Applications Programming Errors and solutions.

Get Excel Column Name in excel sheet Just write in macro of excel in module this code Public Function ConvertToLetter(iCol As Integer) As String Dim columnName As String Dim modulo As Integer While iCol > 0 modulo = (iCol - 1) Mod 26 columnName = Chr(65 + modulo) + columnName iCol = Int((iCol - modulo) / 26) Wend ConvertToLetter = columnName End Function and call in your sheet