/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 vote228 views1 answer
Remove series name from legendvbnet
VBA
1 vote230 views1 answer
Excel vba get column number from column name
VBA
0 vote249 views1 answer
Excel vba ternary
VBA
0 vote236 views1 answer
Thread sleep vb
VBA
0 vote240 views1 answer
Default host vbox address
VBA
0 vote261 views1 answer
Excel vba round to whole number
VBA
0 vote224 views1 answer
Vb streamreader
VBA
0 vote225 views1 answer
Vba collection key list
VBA
0 vote229 views1 answer
Loop through lines in text file vb net
VBA
0 vote277 views2 answers
Excel vba store array and write to sheet
VBA

Share