/VBA/Excel vba Column Name from Column Number

Excel vba Column Name from Column Number

' Column name to column number
ColName = "A"
Debug.Print Range(ColName & 1).Column    ' 1
' Column number to column name
ColNb = 1
Debug.Print Split(Cells(, ColNb).Address, "$")(1)

Source: stackoverflow.com

Similar codes

2 votes361 views2 answers
Excel vba if sunday or staurday
VBA
0 vote358 views1 answer
Windows Forms dark title bar
VBA
0 vote341 views1 answer
Add text to combobox drop down vb
VBA
25 votes467 views2 answers
Excel vba folder exist
VBA
0 vote293 views1 answer
Excel vba arrondir
VBA
0 vote343 views1 answer
Send webhook vbscript
VBA
2 votes315 views1 answer
Vba array contains
VBA
0 vote310 views1 answer
Putting marquee in vb.net
VBA
0 vote324 views1 answer
Excel vba automatic calculation
VBA
0 vote348 views1 answer
Vba variable number of arguments
VBA