Convert kolom letter naar kolom nummer

If you have a column letter and want to turn it into a number, you can use the followingapproach:

numberColumn = Worksheets(1).Columns(AlphaColumn).Column

numberColumn = Sheets(“Blad1”).Columns(“J”).Column 

Result = 10