/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 vote216 views1 answer
Vbnet convert charatcer to binary
VBA
0 vote195 views1 answer
Vbs expand env var
VBA
0 vote212 views1 answer
Vba sheet hide unhide
VBA
0 vote197 views1 answer
Vba min
VBA
1 vote201 views1 answer
Shortcut to apply a formula to an entire column in excel
VBA
1 vote206 views1 answer
Vba ubound array 2-dimensional
VBA
0 vote181 views1 answer
Excel vba populate array with cell values
VBA
-1 vote203 views1 answer
VBA check if a cell contains a letter or string
VBA
0 vote194 views1 answer
Excel vba disable alerts
VBA
0 vote195 views1 answer
Vba round to 2 decimals
VBA