/VBA/Excel vba column letter

Excel vba column letter

Excel vba function to convert column number to letter

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

31

Source: academy.excelhero.com

Excel vba column letter

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

1

Similar codes

2 votes135 views2 answers
Constructor vb.net
VBA
0 vote144 views1 answer
Vba add month to date
VBA
0 vote150 views1 answer
Excel vba delete folder
VBA
0 vote179 views1 answer
Excel vba unlock sheet without password
VBA
0 vote157 views1 answer
Dlete rows with blanks and space " " vba
VBA
0 vote144 views1 answer
Type excel.application is not defined vb
VBA
0 vote145 views1 answer
Excel vba scroll to cell
VBA
1 vote146 views1 answer
Excel vba Run a Macro every time sheet is changed
VBA
0 vote153 views1 answer
Filesystemobject vba reference
VBA
0 vote153 views1 answer
Vba is integer
VBA

Share