/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 vote155 views1 answer
Excel autofilter vba
VBA
0 vote199 views1 answer
Columns dont autoresize on program start vb.net
VBA
0 vote205 views2 answers
S yyyy-MM-dd em vb net
VBA
3 votes184 views1 answer
Vba make long from two words
VBA
3 votes178 views1 answer
Excel vba get the workbook full file name with path
VBA
0 vote127 views1 answer
Vba code to remove leading and trailing spaces
VBA
0 vote181 views1 answer
Excel vba unlock sheet without password
VBA
1 vote186 views1 answer
Vba date to unix timestamp
VBA
0 vote171 views1 answer
Vba type
VBA
2 votes173 views2 answers
Excel vba copy values range to another range
VBA

Share