/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 vote125 views1 answer
Vba extract filename from path
VBA
0 vote121 views1 answer
Excel vba join variant array
VBA
1 vote130 views1 answer
Vbs run
VBA
0 vote115 views1 answer
Excel vba disable screen update
VBA
1 vote119 views1 answer
Add a index column power bi
VBA
0 vote125 views1 answer
Excel vba cell on change
VBA
2 votes142 views2 answers
Excel vba if sunday or staurday
VBA
0 vote135 views1 answer
Vba check if class implements interface
VBA
0 vote129 views1 answer
Set column width of datagridview vb.net
VBA
3 votes143 views1 answer
Extract word in a text in excel
VBA

Share