/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 vote353 views1 answer
Excel vba cell on change
VBA
0 vote371 views1 answer
Add text to Shape VBA
VBA
1 vote409 views1 answer
Perform http request in vb.net
VBA
0 vote338 views1 answer
Change "location" of binding navigator vb
VBA
0 vote323 views1 answer
Enter into cells data grid view
VBA
0 vote342 views1 answer
Label de tableau dans des label.text en VBA
VBA
0 vote367 views1 answer
Excel vba disable screen update
VBA
0 vote337 views1 answer
Vba dictionary length
VBA
3 votes379 views2 answers
Vba date to string
VBA
1 vote347 views1 answer
Add control vb
VBA