/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 vote139 views1 answer
How to remove zeros in excel
VBA
0 vote121 views1 answer
Convert unix to date vba
VBA
0 vote120 views1 answer
Vba copy paste value only
VBA
0 vote128 views1 answer
Vba full date format
VBA
0 vote129 views1 answer
Programmatically copy data from one workshet to another excel
VBA
0 vote133 views1 answer
Vba dictionary clear
VBA
0 vote139 views2 answers
S yyyy-MM-dd em vb net
VBA
0 vote124 views1 answer
Make your computer talk vbscript
VBA
0 vote121 views2 answers
Excel vba close without saving
VBA
1 vote122 views1 answer
If inputbox cancel vba
VBA