How do you use the Excel EOMONTH function in VBA?

I often use Excel functions in VBA:

Application.WorksheetFunction.Sum
Application.WorksheetFunction.Average

etc


I cannot seem to get this to work when using the EMOMONTH function. Is this because it is an addin and must be referenced differently?

Thnx

considering A1 has the date and A2 has the nos of months, use
Evaluate("=EOMONTH(A1,A2)") in your vba, for e.g.

Range("A3") = Evaluate("=EOMONTH(A1,A2)")

- Mangesh