/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

8 votes459 views1 answer
Excel vba make word
VBA
0 vote343 views1 answer
Vbnet add axis labels to chart
VBA
0 vote359 views1 answer
Vba sort the data Z to A
VBA
1 vote343 views1 answer
Excel vba unload userform
VBA
1 vote343 views1 answer
Vba refresh pivot table
VBA
0 vote323 views1 answer
Vb.net visible property dgv collumn not working
VBA
0 vote367 views1 answer
Vbnet revrese the order of character in string
VBA
0 vote330 views1 answer
Vba paste values
VBA
0 vote343 views1 answer
Vba check if class implements interface
VBA
0 vote381 views1 answer
Method showalldata of object _worksheet failed vba
VBA

Share