convert – Useful code

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

By Vitosh Posted on February 23, 2021 Posted in VBA \ Excel Tagged with Column Number to Letter, convert, Excel, letter to column number, VBA

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 …

VBA – Convert Excel Column Number to Letter and Letter to Column Number Read more »

VBA – Convert Month Name to Number and Vice Versa

By Vitosh Posted on May 29, 2020 Posted in VBA \ Excel Tagged with convert, month name, MonthName, MonthNumber, name to number, number

Convert number to name – [3 -> March] Converting month number to name in VBA is actually coming out of the box with the MonthName() function, which is built-in the stanard VBA library: Sub MonthNameExample() Dim i As Long For …

VBA – Convert Month Name to Number and Vice Versa Read more »

Tag: convert

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

VBA – Convert Month Name to Number and Vice Versa