/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

2 votes141 views1 answer
Excel vba check if string entirely alpha
VBA
0 vote132 views1 answer
Vba run command
VBA
0 vote128 views1 answer
Get current url vb.net
VBA
1 vote126 views1 answer
Vba delete array element
VBA
31 votes237 views1 answer
Excel-vba how to convert a column number into an excel column
VBA
0 vote135 views1 answer
Worksheet.pastespecial textbox
VBA
0 vote135 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
5 votes143 views1 answer
Excel vba right word from Long Integer
VBA
0 vote136 views1 answer
Weekday vba
VBA
0 vote131 views1 answer
Excel vba protect sheet
VBA