/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

-1 vote321 views2 answers
How close excel through visual basic
VBA
2 votes317 views1 answer
Date format for ms chart vb.net
VBA
1 vote353 views2 answers
Get all column names from excel vba
VBA
0 vote318 views1 answer
Do until vb.net
VBA
0 vote365 views2 answers
Vb.net include quotes in string
VBA
1 vote336 views1 answer
How to check is the value enterd is a number or text in vba
VBA
0 vote317 views2 answers
Excel vba close without saving
VBA
3 votes334 views2 answers
Excel "vba" match last value
VBA
0 vote355 views1 answer
How to enter Vbox manage commands
VBA
0 vote358 views1 answer
Vba random number
VBA