excel vba function to convert column number to letter excel vba column letter

The solution for “excel vba function to convert column number to letter excel vba column letter” can be found here. The following code will assist you in solving the problem.

Function ColName(n)
ColName = Split(Cells(, n).Address, “$”)(1)
End FunctionFunction ColumnLetter(pColIndex As Long) As String
ColumnLetter = Replace(Cells(1, pColIndex).Address(True, False), “$1”, “”)
End Function

Thank you for using DeclareCode; We hope you were able to resolve the issue.

More questions on [categories-list]

Similar Posts