/VBA/Excel vba Column Name from Column Number

Excel vba Column Name from 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 vote228 views1 answer
Excel PasteSpecial Format:= can't find the argument
VBA
0 vote218 views1 answer
Vba createparameter null
VBA
0 vote238 views1 answer
Supprimer la valeur de celule vba
VBA
0 vote250 views1 answer
For each item in folder outlook vba
VBA
0 vote240 views1 answer
Vba string
VBA
0 vote232 views1 answer
Nested if else in vb.net
VBA
0 vote235 views4 answers
How to continue formula in below line in vba code
VBA
0 vote289 views1 answer
Visual basic run command
VBA
0 vote238 views1 answer
Check if program is running vbnet
VBA
1 vote230 views1 answer
Change the first item in a queue vb.net
VBA