/VBA/Excel vba Column Name to Column Number

Excel vba Column Name to 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 vote191 views1 answer
Vba line feed
VBA
0 vote118 views1 answer
Excel autofilter vba
VBA
0 vote190 views1 answer
VBA
VBA
4 votes204 views1 answer
Excel vba how to get a range's full address including sheet name
VBA
0 vote177 views1 answer
Convert unix to date vba
VBA
3 votes202 views1 answer
Extract word in a text in excel
VBA
0 vote175 views1 answer
Excel vba range contains
VBA
0 vote190 views1 answer
Tester si une case est vide vba
VBA
9 votes333 views2 answers
Excel vba convert 2 Short integers to a Long integer
VBA
0 vote197 views1 answer
Vba vbcrlf chr
VBA