/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 vote239 views1 answer
Excel vba protect scenarios
VBA
0 vote219 views1 answer
Enable macros on opening workbook vba
VBA
-1 vote252 views1 answer
How to correct a number to 2 decimal places in vba
VBA
5 votes244 views1 answer
Excel vba left word from Long Integer
VBA
1 vote196 views1 answer
Vba listindex select multiple items vba
VBA
0 vote218 views1 answer
Vlookup columns not next to each other
VBA
5 votes197 views1 answer
Vba array worksheet.index
VBA
0 vote267 views1 answer
Excel vba protect content
VBA
1 vote224 views1 answer
Excel vba get column number from column name
VBA
2 votes205 views1 answer
Vba array contains
VBA

Share