/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 vote196 views1 answer
Code for reading letters only in vb 6
VBA
0 vote184 views1 answer
Vba copy file
VBA
0 vote181 views1 answer
Vba format currency
VBA
0 vote175 views1 answer
Vba verticalalignment
VBA
0 vote198 views1 answer
How to enter Vbox manage commands
VBA
0 vote163 views1 answer
Excel vba center userform
VBA
0 vote199 views1 answer
Build an index all files of a FTP site
VBA
0 vote240 views2 answers
VB
VBA
0 vote204 views1 answer
Vba cell all borders
VBA
1 vote168 views2 answers
Get all column names from excel vba
VBA

Share