/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 vote139 views1 answer
Docker vboxmanage not found
VBA
0 vote155 views1 answer
Excel vba StartUpPosition
VBA
0 vote147 views1 answer
Vba get text file content
VBA
0 vote162 views1 answer
Vba horizontalalignment
VBA
0 vote141 views1 answer
Replace spaces with underscores vbnet
VBA
0 vote157 views1 answer
Vbnet find highest value in chart
VBA
0 vote151 views1 answer
Remove last 8 characters from string vb
VBA
0 vote163 views4 answers
Jwt token vb.net validation
VBA
0 vote201 views2 answers
Excel vba store array and write to sheet
VBA
18 votes322 views2 answers
Vba make word from bytes
VBA