how to convert a column to number format in excel code example

Example 1: excel vba function to convert column number to letter

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

Example 2: convert int to excel column name

Function converts column index to excel column character