convert – Useful code

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

Posted on February 23, 2021 by

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…

VBA – Convert Month Name to Number and Vice Versa

Posted on May 29, 2020 by

Vitosh Posted in VBA \ Excel

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 i = 1 To 12
        Debug.Print MonthName(i)
        Debug.Print Format(MonthName(i, True))
    Next
    
End Sub

Sub MonthNameExample()

Dim i As Long

For i = 1 To 12

Debug.Print MonthName(i)

Debug.Print Format(MonthName(i, True))

End Sub

The result is not flabbergasting, but…

Tag: convert

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

VBA – Convert Month Name to Number and Vice Versa