/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 vote298 views1 answer
Vba get text file content
VBA
20 votes454 views1 answer
Excel vba factorial
VBA
0 vote321 views1 answer
Excel vba StartUpPosition
VBA
0 vote282 views1 answer
Vba select file in folder
VBA
0 vote303 views1 answer
Vb check if row has column
VBA
0 vote306 views1 answer
Vba option button selected
VBA
2 votes343 views2 answers
Excel vba if sunday or staurday
VBA
0 vote299 views1 answer
Remove first character from string vb
VBA
0 vote302 views1 answer
Excel vba current folder
VBA
0 vote325 views1 answer
Vb ternary
VBA

Share