/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 vote287 views1 answer
Vba format currency
VBA
0 vote291 views1 answer
Reset border color textbox vba
VBA
0 vote283 views1 answer
Vb window.minimize
VBA
0 vote305 views1 answer
Weekday vba
VBA
0 vote282 views1 answer
Vba string start with
VBA
3 votes301 views1 answer
Vba not equal
VBA
0 vote320 views1 answer
Iterate all file in a folder vba
VBA
0 vote303 views1 answer
System.InvalidOperationException: 'Row associated with the currency manager's position cannot be made invisible.
VBA
0 vote311 views1 answer
Excel vba disable screen update
VBA
0 vote353 views1 answer
Winforms dark title bar
VBA

Share