/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

0 vote160 views1 answer
Vba format currency
VBA
0 vote149 views1 answer
Vb net show lines for all axis labels in chart
VBA
0 vote180 views1 answer
Wpf dark title bar
VBA
0 vote172 views1 answer
Vba random number
VBA
0 vote162 views1 answer
Vba horizontalalignment
VBA
0 vote161 views1 answer
Build an index all files of a FTP site
VBA
0 vote159 views1 answer
Excel vba automatic calculation
VBA
2 votes150 views1 answer
Excel vba check if string entirely numeric
VBA
0 vote149 views1 answer
Send webhook vbscript
VBA
0 vote155 views1 answer
Nested if else in vb.net
VBA

Share