/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

2 votes124 views1 answer
Excel vba date to string conversion
VBA
0 vote121 views1 answer
Vba get relative cell address
VBA
5 votes156 views1 answer
Vba low word from Long Integer
VBA
0 vote128 views1 answer
Filesystemobject vba reference
VBA
0 vote131 views1 answer
Search combobox items vb.net
VBA
8 votes144 views1 answer
Run command pormpt in background windows
VBA
7 votes128 views1 answer
Vba array declaration
VBA
7 votes144 views1 answer
Excerl vba array to range
VBA
0 vote122 views1 answer
Excel vba protect sheet
VBA
3 votes120 views1 answer
Extract the nth word from a text string
VBA

Share