/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 vote163 views1 answer
Do while not vb.net
VBA
0 vote221 views1 answer
Excel vba delete columns in range
VBA
1 vote177 views1 answer
Set font for ms chart vb.net
VBA
0 vote178 views1 answer
Power query M substract minimum value of column -dax
VBA
5 votes183 views1 answer
Excel vba second byte from INTEGER
VBA
0 vote166 views1 answer
Remove last 8 characters from string vb
VBA
1 vote119 views1 answer
Vba Remove Case Sensitivity
VBA
0 vote165 views1 answer
Vba get workbook name
VBA
3 votes219 views2 answers
Excel "vba" match last value
VBA
0 vote167 views1 answer
Vba shape transparent
VBA