/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 vote245 views1 answer
Search for text in every worksheet excel visual basic
VBA
0 vote264 views1 answer
Vba ternary
VBA
0 vote211 views1 answer
Vbnet line graph smooth lines
VBA
0 vote237 views2 answers
Excel vba protect cells with formula
VBA
0 vote226 views1 answer
Sort dictionary by key vba
VBA
0 vote215 views1 answer
Add items to combobox vb.net
VBA
0 vote221 views1 answer
How to convert weeks to days into textbox with VB site:stackoverflow.com
VBA
0 vote286 views1 answer
Vba is integer
VBA
0 vote259 views1 answer
Vba code for cutoff time
VBA
0 vote226 views1 answer
How to carry text to the next line in a label in vb.net
VBA