/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 vote189 views1 answer
Vba pass named range to function
VBA
0 vote283 views1 answer
Vba change active sheet
VBA
0 vote196 views1 answer
Vba DisplayGridlines
VBA
1 vote185 views1 answer
Vba delete array element
VBA
4 votes203 views2 answers
Excel vba last column with data
VBA
0 vote228 views1 answer
Vba registry settings
VBA
0 vote200 views1 answer
Vbnet chart make 0 gridline line different color
VBA
0 vote201 views1 answer
Excel vba copy range with filter
VBA
0 vote199 views1 answer
Windows Presentation Foundation dark title bar
VBA
0 vote200 views1 answer
Excel vba saveas no prompt for overwrite
VBA

Share