/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

15 votes365 views1 answer
Excel vba wait
VBA
0 vote291 views1 answer
Excel web scraping
VBA
0 vote290 views1 answer
Excel last used row
VBA
3 votes277 views1 answer
Excel insert blank row for value change in column
VBA
1 vote268 views1 answer
Excel vba compare 2 rows
VBA
0 vote290 views1 answer
Vba registry settings
VBA
0 vote279 views1 answer
Excel vba join variant array
VBA
3 votes261 views1 answer
Excel vba read registry key value
VBA
0 vote265 views1 answer
Label de tableau dans des label.text en VBA
VBA
25 votes371 views2 answers
Excel vba folder exist
VBA

Share