Get Excel Column Name in excel sheet
Just write in macro of excel in module this code
and call in your 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