/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 vote161 views1 answer
Excel vba join variant array
VBA
1 vote178 views1 answer
How to INPUT text in shape with enter and spacein vba
VBA
1 vote156 views1 answer
Excel vba saveas force overwrite
VBA
8 votes189 views1 answer
Run command pormpt in background windows
VBA
0 vote168 views1 answer
Vbscript abs
VBA
5 votes195 views1 answer
Excel vba last byte from INTEGER
VBA
3 votes206 views2 answers
Vba date to string
VBA
0 vote175 views1 answer
Vba format currency
VBA
1 vote156 views2 answers
Vba remove first 2 characters from string
VBA
4 votes159 views1 answer
Excel vba check cell not empty
VBA

Share