/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

1 vote137 views1 answer
Excel vba array remove first
VBA
0 vote132 views1 answer
Send webhook vbscript
VBA
0 vote145 views2 answers
Checking and changing system volume vb.net
VBA
0 vote127 views1 answer
Excel vba join variant array
VBA
7 votes152 views1 answer
Excerl vba array to range
VBA
0 vote131 views1 answer
Telephon call in vba
VBA
0 vote147 views1 answer
Vba round to 2 decimals
VBA
4 votes128 views1 answer
Vba create directory
VBA
0 vote124 views1 answer
Excel vba disable copy paste
VBA
18 votes264 views3 answers
Excel-vba make integer
VBA