/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

1 vote308 views1 answer
Add control vb
VBA
1 vote348 views1 answer
Vba login website
VBA
1 vote303 views1 answer
Excel date to unix timestamp
VBA
0 vote328 views1 answer
Excel vba protect sheet
VBA
0 vote353 views1 answer
Vbs run with cscript
VBA
2 votes307 views2 answers
Vba code to remove duplicates from a column
VBA
0 vote288 views1 answer
Vbide vbproject reference
VBA
3 votes302 views1 answer
Excel vba export sheet as a csv without losing focus of my current workbook
VBA
0 vote317 views1 answer
Excel vba StartUpPosition
VBA
1 vote309 views1 answer
Excel format cell as kilowatts
VBA