/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

3 votes215 views1 answer
Vba http request json
VBA
0 vote216 views2 answers
Excel vba protect cells with formula
VBA
0 vote205 views1 answer
Average vba
VBA
0 vote226 views1 answer
Search for text in every worksheet excel visual basic
VBA
0 vote216 views1 answer
Remove first character from string vb
VBA
0 vote206 views1 answer
Dynamic array vba
VBA
0 vote233 views1 answer
Excel vba round to whole number
VBA
0 vote224 views1 answer
Excel vba DisplayAlerts
VBA
18 votes533 views2 answers
Vba make word from bytes
VBA
0 vote218 views1 answer
Vba variable number of arguments
VBA