/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

0 vote137 views1 answer
Compare dates vb
VBA
0 vote136 views1 answer
Selecttoken em vbnet e json
VBA
0 vote134 views1 answer
Vba remove numbers from string
VBA
5 votes154 views1 answer
Excel-vba get integer high byte
VBA
1 vote130 views2 answers
Vba string to date
VBA
2 votes93 views2 answers
Vba exit loop
VBA
0 vote141 views1 answer
Xlbycolumns is not declared
VBA
0 vote131 views1 answer
How to use VBA to add new record in MS Access?
VBA
0 vote170 views1 answer
Vbnet check if string is only letters
VBA
0 vote138 views1 answer
Vbscript check if string is empty
VBA

Share