/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 vote150 views1 answer
Do while not vb.net
VBA
0 vote154 views1 answer
Vba code to select image in sheet
VBA
12 votes285 views1 answer
Excel vba write string to text file
VBA
1 vote148 views1 answer
Excel vba get ordinal number from cardinal number
VBA
0 vote151 views1 answer
Excel vba current folder
VBA
0 vote103 views1 answer
How to sort datagridview in vb.net
VBA
0 vote162 views1 answer
.net dark title bar
VBA
1 vote158 views1 answer
Excel vba Refreshing all pivot tables in workbook
VBA
0 vote150 views1 answer
Loop through lines in text file vb net
VBA
0 vote151 views1 answer
How to extract a file from an ISO:
VBA

Share