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.
Thank you!
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.
VBA Code:
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!