/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 vote180 views1 answer
How to use if condition in time vba
VBA
0 vote183 views1 answer
Vba full date format
VBA
1 vote179 views1 answer
Excel vba get ordinal number from cardinal number
VBA
1 vote190 views1 answer
Shortcut to apply a formula to an entire column in excel
VBA
0 vote208 views1 answer
Excel vba move down to next visible cell
VBA
3 votes193 views1 answer
Vba http request json
VBA
3 votes186 views1 answer
Vba not equal
VBA
0 vote192 views2 answers
Do until loop vba
VBA
1 vote185 views1 answer
Change the first item in a queue vb.net
VBA
3 votes203 views1 answer
Excel vba make long from two shorts
VBA

Share