/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 vote177 views1 answer
Vba option button selected
VBA
0 vote179 views1 answer
How to mount floppy disks in vb.net
VBA
1 vote169 views1 answer
Excel vba Populating a combobox on a userform from a range of cells
VBA
5 votes194 views1 answer
Excel vba tool to help with refactoring code
VBA
0 vote195 views1 answer
Iterate all file in a folder vba
VBA
0 vote179 views1 answer
Average vba
VBA
3 votes227 views2 answers
Excel "vba" match last value
VBA
0 vote174 views1 answer
Remove last 8 characters from string vb
VBA
0 vote189 views1 answer
Excel vba protect worksheet without password
VBA
0 vote185 views2 answers
Excel vba number format file size
VBA

Share