/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 vote139 views1 answer
If statement vdhl
VBA
1 vote121 views1 answer
Shortcut to apply a formula to an entire column in excel
VBA
0 vote123 views1 answer
Vba declare 64-bit ptrsafe
VBA
0 vote128 views1 answer
Check if cell is dbnullvb.net
VBA
0 vote126 views1 answer
Vba sort multiple columns
VBA
0 vote118 views1 answer
Thread sleep vb
VBA
0 vote112 views1 answer
Loop through lines in text file vb net
VBA
0 vote142 views1 answer
Weekday vba
VBA
0 vote127 views1 answer
How to convert weeks to days into textbox with VB site:stackoverflow.com
VBA
0 vote114 views1 answer
Create new worksheet excel visual basic
VBA