/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

1 vote360 views1 answer
How to do error handling in access vba
VBA
0 vote346 views1 answer
Vb net dgv doesn't keep currency format
VBA
1 vote364 views1 answer
Excel vba unload userform
VBA
3 votes401 views1 answer
Vba post request json
VBA
1 vote369 views1 answer
Excel vba saveas force overwrite
VBA
0 vote377 views2 answers
Checking and changing system volume vb.net
VBA
0 vote369 views1 answer
Vbnet hex to binary
VBA
22 votes525 views1 answer
Xlvba check for folder
VBA
-1 vote379 views2 answers
Excel vba delete empty rows
VBA
27 votes514 views2 answers
Vba check if file exists
VBA

Share