/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 vote298 views1 answer
Find control with name vb
VBA
0 vote292 views1 answer
Vba add shape oval
VBA
0 vote281 views1 answer
Vlookup columns not next to each other
VBA
3 votes286 views1 answer
Vba folderexists
VBA
0 vote284 views1 answer
Telephon call in vba
VBA
2 votes301 views1 answer
Vba file from path
VBA
22 votes470 views1 answer
Xl vba check for folder
VBA
0 vote293 views1 answer
Excel vba disable keyboard input
VBA
0 vote280 views1 answer
Refresh token em vb net
VBA
0 vote285 views1 answer
Excel vba show developer tab
VBA