/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 vote170 views1 answer
Refresh token em vb net
VBA
0 vote174 views1 answer
Vbnet check if number is even or odd
VBA
0 vote180 views1 answer
Rotate image by any angle vb.net
VBA
1 vote161 views1 answer
Excel vba first and last row and column in range
VBA
0 vote208 views1 answer
How to enter Vbox manage commands
VBA
5 votes160 views1 answer
Excel vba high word from Long Integer
VBA
0 vote168 views1 answer
Excel PasteSpecial Format:= can't find the argument
VBA
0 vote176 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
20 votes236 views1 answer
Excel vba recursive example factorial function
VBA
1 vote186 views1 answer
Excel vba array remove first
VBA