/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 vote226 views1 answer
Freeze panes vba
VBA
0 vote211 views1 answer
Excel named range sum
VBA
0 vote204 views1 answer
Excel vba assign shortcut key to button
VBA
15 votes499 views2 answers
Xl vba dynamic string array
VBA
1 vote207 views1 answer
How to put a gridpain in a vbox
VBA
3 votes259 views2 answers
Excel "vba" match last value
VBA
0 vote208 views1 answer
Vb streamreader
VBA
1 vote193 views1 answer
Excel vba convert cells(1,1) into A1 and vice versa
VBA
3 votes237 views2 answers
Vba active workbook path
VBA
0 vote231 views1 answer
Vba code to select image in sheet
VBA

Share