/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 vote370 views1 answer
How to use if condition in time vba
VBA
0 vote447 views2 answers
Excel vba store array and write to sheet
VBA
0 vote366 views1 answer
Vba code for cutoff time
VBA
3 votes356 views1 answer
Excel vba change format of cell
VBA
0 vote358 views1 answer
Find the name of the last excel sheet vb
VBA
8 votes464 views1 answer
Excel vba make a short integer from two bytes
VBA
0 vote360 views1 answer
Do while not vb.net
VBA
0 vote374 views1 answer
VBA is form loaded
VBA
0 vote383 views1 answer
Add text to Shape VBA
VBA
0 vote391 views1 answer
Create links in msgbox in vb
VBA