/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 votes140 views2 answers
Excel vba copy values range to another range
VBA
3 votes161 views1 answer
Vba double quote
VBA
0 vote150 views1 answer
Dynamic array vba
VBA
0 vote164 views1 answer
Delete all controls in an area vb
VBA
0 vote196 views1 answer
Excel vba protect content
VBA
5 votes181 views1 answer
Vba low word from Long Integer
VBA
4 votes151 views2 answers
Excel vba last column with data
VBA
0 vote148 views1 answer
Excel vba prevent saving workbook
VBA
0 vote159 views1 answer
Power query M substract minimum value of column -dax
VBA
0 vote133 views1 answer
Vba argument is set
VBA