/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 vote218 views1 answer
Add control vb
VBA
1 vote214 views2 answers
Vba remove first 2 characters from string
VBA
0 vote225 views1 answer
Excel vba unmerge sheet
VBA
2 votes223 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA
0 vote254 views2 answers
Excel vba number format file size
VBA
3 votes208 views1 answer
Excel vba read registry key value
VBA
0 vote227 views1 answer
Excel VBA web scraping
VBA
9 votes282 views2 answers
Excel vba convert 2 Short integers to a Long integer
VBA
0 vote215 views1 answer
Vba timestamp -- milliseconds
VBA
-1 vote205 views1 answer
System.Data.OleDb.OleDbException: 'No value given for one or more required parameters.'
VBA

Share