/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 vote252 views1 answer
Find the name of the last excel sheet vb
VBA
4 votes174 views1 answer
VBA Deep Clone Dictionary
VBA
0 vote155 views1 answer
Vba code for cutoff time
VBA
0 vote149 views1 answer
Excel vba milliseconds
VBA
0 vote161 views1 answer
How to convert weeks to days into textbox with VB site:stackoverflow.com
VBA
0 vote149 views1 answer
Docker vboxmanage not found
VBA
0 vote149 views1 answer
Vba first cell in range
VBA
0 vote158 views1 answer
Vb net dgv doesn't keep currency format
VBA
0 vote170 views1 answer
Vba min
VBA
0 vote158 views2 answers
How to concatenate more than 40 lines in vba
VBA

Share