/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 vote34 views1 answer
Vba compare strings
VBA
0 vote34 views1 answer
Vbnet find highest value in chart
VBA
5 votes36 views1 answer
Vba low byte from INTEGER
VBA
1 vote32 views1 answer
Excel vba first row in range
VBA
2 votes35 views1 answer
Vba split string
VBA
0 vote39 views1 answer
Arq linux
VBA
0 vote35 views1 answer
Group controls programmatically vb
VBA
0 vote37 views1 answer
Excel vba show developer tab
VBA
2 votes38 views2 answers
Vba code to remove duplicates from a column
VBA
0 vote33 views1 answer
Excel vba milliseconds
VBA

Share