/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 vote229 views1 answer
Vba border weight
VBA
0 vote232 views1 answer
Vbscript abs
VBA
31 votes532 views1 answer
Excel vba function to convert column number to letter
VBA
0 vote288 views1 answer
Winforms dark title bar
VBA
0 vote238 views1 answer
Vba string start with
VBA
0 vote238 views1 answer
Excel vba hide columns
VBA
0 vote237 views1 answer
Vb test if reference is null
VBA
5 votes241 views1 answer
Excel vba highlight cells using the hex color value within the cells
VBA
0 vote282 views1 answer
Excel vba round to whole number
VBA
0 vote245 views1 answer
Vba array dimensions
VBA

Share