/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 vote232 views1 answer
Excel vba first column in range
VBA
1 vote222 views1 answer
Excel vba How to determine if a date falls on the weekend?
VBA
0 vote216 views1 answer
Excel vba cell on change
VBA
5 votes228 views1 answer
Excel vba low word from Long Integer
VBA
0 vote203 views1 answer
Vba loop through table
VBA
0 vote212 views1 answer
Excel vba remove formatting from cell
VBA
0 vote222 views1 answer
Excel vba prevent saving workbook
VBA
6 votes214 views1 answer
Excel vba check if a string only contains letters
VBA
0 vote220 views1 answer
Excel vba urlmon
VBA
25 votes263 views2 answers
Excel vba folder exist
VBA

Share