/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 vote306 views1 answer
How to mount floppy disks in vb.net
VBA
0 vote278 views1 answer
Excel vba disable mouse click
VBA
1 vote261 views1 answer
Vba Remove Case Sensitivity
VBA
0 vote286 views1 answer
Vba option button selected
VBA
0 vote307 views1 answer
Excel vba send HTTP POST to server
VBA
0 vote294 views1 answer
Vb run command
VBA
0 vote285 views1 answer
Vba sort multiple columns
VBA
0 vote298 views1 answer
Return na vba
VBA
2 votes292 views1 answer
Excel vba check if string entirely numeric
VBA
0 vote288 views1 answer
Vba code to open a file with login rights
VBA

Share