Populated a variable with a formula

[rvgray]

Hello,

I am trying to populate my variable called PeriodDate with an End Of Month formula through VBA.
What I typed is below:

PeriodDate = EOMonth(....)

what happens after it adjusts is:

PeriodDate = EoMonth(....)

Could somebody please explain what I'm doing wrong?

Thanks

[YasserKhalil]

Hello
You can use evaluate for EOMonth

Please Login or Register  to view this content.

[jindon]

Please Login or Register  to view this content.

[rvgray]

Thank you this worked!