Return month

[288enzo]

Hi all,

I would love to know why this isn't working. It seems fairly straight forward.

The error I'm getting is a Compile error: Wrong number of arguments or invalid property assignment. Format is highlighted.

Sub my_test()
    Dim str As String
    str = Format(Range("M2"), "MMMM")
    Debug.Print str
End Sub

Feb 1 - Feb 28.xlsx
	M
2	2/17/2023
KPI Data

Thank you!

 

[FormR]

Hi, do you have a Sub, Function or Module called "Format"?

 

[288enzo]

Hi, do you have a Sub, Function or Module called "Format"?

Bingo, thank you!