Question : excel vba function to convert column number to letter
Answered by : daniel-ferry
Function ColName(n) ColName = Split(Cells(, n).Address, "$")(1)
End Function
Source : http://academy.excelhero.com/ | Last Update : Mon, 06 Apr 20
Question : excel vba column letter
Answered by : vastemonde
Function ColumnLetter(pColIndex As Long) As String ColumnLetter = Replace(Cells(1, pColIndex).Address(True, False), "$1", "")
End Function
Source : | Last Update : Tue, 26 Jan 21