/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

25 votes415 views3 answers
String to date vb
VBA
1 vote272 views1 answer
Highlight selected cell in excel vba
VBA
0 vote290 views1 answer
Average vba
VBA
0 vote298 views1 answer
Vba add spaces
VBA
0 vote243 views1 answer
How to sort datagridview in vb.net
VBA
0 vote273 views1 answer
Check range is in another range vba
VBA
0 vote321 views1 answer
Excel vba convert cells address
VBA
0 vote281 views1 answer
Vba shape transparent
VBA
1 vote269 views2 answers
Excel vba password protect
VBA
1 vote289 views1 answer
Vba date to unix timestamp
VBA

Share