/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 vote237 views1 answer
Visual basic msdos
VBA
0 vote250 views2 answers
Excel vba number format file size
VBA
0 vote236 views1 answer
Excel vba range contains
VBA
0 vote251 views1 answer
Tester si une case est vide vba
VBA
0 vote270 views1 answer
Vbnet cycle through charaters in string
VBA
1 vote230 views1 answer
Excel vba get column name from number
VBA
0 vote224 views1 answer
Vbnet get file name from path
VBA
0 vote237 views1 answer
Loop through each cell in dgv vbnet
VBA
5 votes262 views1 answer
Excel vba tool to help with refactoring code
VBA
0 vote233 views1 answer
Vlookup columns not next to each other
VBA