/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 vote190 views1 answer
Windows Forms dark title bar
VBA
0 vote191 views1 answer
Thread sleep vb
VBA
1 vote173 views1 answer
Vba delete array element
VBA
0 vote185 views1 answer
Vba sheet hide unhide
VBA
0 vote190 views1 answer
Vba simple quote
VBA
18 votes432 views2 answers
Vba make word from bytes
VBA
0 vote172 views1 answer
Vba get text file content
VBA
0 vote190 views1 answer
Search combobox items vb.net
VBA
0 vote188 views2 answers
Vba remove line breaks
VBA
0 vote187 views1 answer
Vba word open document read only
VBA