/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 vote169 views1 answer
Vba simple quote
VBA
0 vote164 views1 answer
Vba type variable
VBA
-1 vote153 views1 answer
For i in range vba
VBA
0 vote157 views1 answer
Vlookup columns not next to each other
VBA
0 vote164 views1 answer
Show unix time in vba
VBA
0 vote167 views1 answer
Check if program is running vbnet
VBA
0 vote151 views1 answer
Vba len variant
VBA
0 vote238 views1 answer
Application.ExecutablePath VB.NET
VBA
1 vote172 views2 answers
Excel vba password protect
VBA
0 vote150 views1 answer
Excel text to columns line break
VBA