/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

2 votes207 views1 answer
Excel vba check if key is in collection
VBA
31 votes463 views1 answer
Excel-vba how to convert a column number into an excel column
VBA
0 vote232 views1 answer
Columns dont autoresize on program start vb.net
VBA
0 vote240 views2 answers
Get unique random number in vb.net
VBA
0 vote198 views1 answer
Vba copy paste value only
VBA
3 votes201 views1 answer
Vba folderexists
VBA
0 vote214 views1 answer
Average vba
VBA
5 votes205 views1 answer
Excel vba high word from Long Integer
VBA
0 vote165 views10 answers
Vba excel create event log
VBA
0 vote225 views1 answer
Vba copy file
VBA