/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 vote333 views1 answer
Vba extract filename from path
VBA
0 vote306 views1 answer
Select case vba
VBA
0 vote358 views1 answer
Programmatically copy data from one workshet to another excel
VBA
0 vote309 views1 answer
Excel vba saveas no prompt for overwrite
VBA
0 vote341 views1 answer
Supprimer la valeur de celule vba
VBA
0 vote332 views1 answer
Vba random number
VBA
0 vote298 views1 answer
Hello world vb.net
VBA
4 votes317 views1 answer
Excel vba determine number of elements in an array
VBA
0 vote295 views1 answer
Vb net dgv doesn't keep currency format
VBA
0 vote296 views1 answer
Excel PasteSpecial Format:= can't find the argument
VBA

Share