/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 vote272 views4 answers
Vgrive,deb
VBA
0 vote243 views1 answer
Return na vba
VBA
0 vote238 views1 answer
Vba verticalalignment
VBA
0 vote251 views1 answer
Excel vba round to whole number
VBA
1 vote243 views1 answer
Excel date to unix timestamp
VBA
4 votes237 views1 answer
Excel vba check cell not empty
VBA
0 vote255 views1 answer
Add text to Shape VBA
VBA
0 vote256 views1 answer
Vba sort the data Z to A
VBA
0 vote249 views1 answer
Vba excel parser xml
VBA
0 vote263 views1 answer
Excel vba set cell value to empty
VBA

Share