VBA – Convert Excel Column Number to Letter and Letter to Column Number

Converting Excel column number to letter and letter to column number is actually something that every VBA developer does at least once a day. The easiest way is probably to use the property .Column or .Address of the range object that you are using and to play a bit with it.

Not a lot to do with #VBA, just a nice picture from the weekend.

Anyway, if you want to do it with Maths and without using the Excel range properties, this is the way to do it:

And if you want to see some tests, check here:

Enjoy! 🙂

Tagged with: , , , ,