/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

3 votes145 views2 answers
Vba active workbook path
VBA
0 vote137 views1 answer
Excel vba protect worksheet without password
VBA
1 vote134 views1 answer
Vbscript convert ascii code to character
VBA
0 vote144 views2 answers
Checking and changing system volume vb.net
VBA
0 vote162 views1 answer
Wpf dark title bar
VBA
0 vote135 views1 answer
Move bindingnavigator vb
VBA
-1 vote126 views1 answer
For i in range vba
VBA
0 vote127 views1 answer
Handling a click event anywhere inside a panel vb
VBA
0 vote134 views1 answer
Excel vba hide gridlines
VBA
2 votes124 views2 answers
Excel vba copy values range to another range
VBA

Share