/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 vote360 views1 answer
Vba test optional argument
VBA
3 votes360 views1 answer
Extract the nth word from a text string
VBA
0 vote350 views1 answer
Refer to resource using string variable vb.net
VBA
31 votes503 views1 answer
Vba how to convert a column number into an Excel column
VBA
0 vote353 views1 answer
Excel vba move down to next visible cell
VBA
0 vote334 views1 answer
Vb net dgv doesn't keep currency format
VBA
0 vote344 views1 answer
Compare dates vb
VBA
0 vote330 views1 answer
Excel vba disable copy paste
VBA
0 vote368 views1 answer
How to format a textbox as date vb net
VBA
1 vote337 views1 answer
Vbscript convert ascii code to character
VBA

Share