/VBA/Excel vba Column Name to Column Number

Excel vba Column Name to 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

0 vote127 views1 answer
Visual stuiod not recognising desgined labels
VBA
1 vote123 views2 answers
Vba string length
VBA
0 vote136 views1 answer
Programmatically copy data from one workshet to another excel
VBA
1 vote122 views1 answer
How to INPUT text in shape with enter and spacein vba
VBA
0 vote131 views1 answer
Excel vba join variant array
VBA
0 vote129 views1 answer
Vba static variable
VBA
0 vote139 views1 answer
Wpf dark title bar
VBA
0 vote119 views1 answer
Default host vbox address
VBA
5 votes131 views1 answer
Xl vba double quotes in string literal
VBA
0 vote115 views1 answer
Search in richtextbox vb.net
VBA