/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

1 vote220 views1 answer
How to do error handling in access vba
VBA
5 votes254 views1 answer
Excel vba get user selected range
VBA
15 votes460 views1 answer
Excel vba wait
VBA
0 vote209 views1 answer
Vba argument is set
VBA
0 vote303 views1 answer
Excel vba add reference programmatically
VBA
0 vote267 views1 answer
Excel vba round to whole number
VBA
0 vote303 views1 answer
Find control with name vb
VBA
1 vote235 views1 answer
Excel vba to lower case
VBA
0 vote236 views1 answer
Arq linux
VBA
0 vote239 views1 answer
Excel last used row
VBA