/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

1 vote350 views1 answer
Find and replace textbox
VBA
0 vote290 views1 answer
How to self delete a vbscript file
VBA
0 vote348 views1 answer
How to enter Vbox manage commands
VBA
18 votes485 views3 answers
Excel-vba make integer
VBA
0 vote319 views1 answer
Visual stuiod not recognising desgined labels
VBA
0 vote343 views1 answer
Afficher un message d'erreur vba
VBA
8 votes493 views1 answer
Excel vba make word from bytes
VBA
0 vote331 views1 answer
Vba copy file
VBA
0 vote383 views1 answer
Vba foreach 2d array
VBA
0 vote317 views1 answer
Le contrôle SpinButton (Toupie)
VBA

Share