/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 vote288 views1 answer
Group controls programmatically vb
VBA
3 votes284 views1 answer
Vba double quote
VBA
0 vote261 views1 answer
Vba declare 64-bit ptrsafe
VBA
0 vote267 views1 answer
Convert number to minutes in vba
VBA
15 votes366 views1 answer
Excel vba wait
VBA
0 vote276 views1 answer
WGET FTP
VBA
4 votes283 views2 answers
Vba last row
VBA
0 vote271 views1 answer
Vba get application version
VBA
3 votes277 views1 answer
Excel insert blank row for value change in column
VBA
0 vote269 views1 answer
Vba len variant
VBA