Answers for "vba get column as letter"

excel vba function to convert column number to letter

Function ColName(n)
    ColName = Split(Cells(, n).Address, "$")(1)
End Function

Posted by: Guest on March-30-2020

excel vba column letter

Function ColumnLetter(pColIndex As Long) As String
    ColumnLetter = Replace(Cells(1, pColIndex).Address(True, False), "$1", "")
End Function

Posted by: Guest on January-19-2021

Code answers related to "vba get column as letter"