/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 vote196 views1 answer
Excel vba remove formatting from cell
VBA
0 vote255 views1 answer
Visual basic cmd
VBA
-1 vote202 views1 answer
VBA check if a cell contains a letter or string
VBA
4 votes206 views1 answer
Vba create directory
VBA
0 vote246 views1 answer
Vba userform textbox wrap text
VBA
0 vote218 views1 answer
Vba keep command window open
VBA
0 vote248 views1 answer
Vba excel parser xml
VBA
1 vote214 views1 answer
Vba login website
VBA
0 vote157 views1 answer
Excel vba arrondir
VBA
0 vote265 views1 answer
Find control with name vb
VBA

Share