/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 vote366 views1 answer
Vba first cell in range
VBA
9 votes508 views2 answers
Excel vba convert 2 Short integers to a Long integer
VBA
0 vote335 views1 answer
Check if program is running vbnet
VBA
1 vote380 views1 answer
How to remove zeros in excel
VBA
0 vote349 views1 answer
Excel PasteSpecial Format:= can't find the argument
VBA
0 vote348 views1 answer
Telephon call in vba
VBA
8 votes427 views1 answer
Excel vba make integer
VBA
3 votes398 views1 answer
Vba double quote
VBA
0 vote356 views1 answer
Excel run macro every 5 minutes
VBA
0 vote344 views1 answer
How to carry text to the next line in a label in vb.net
VBA

Share