Get Excel Column Name in excel sheet

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